Free Oracle 1Z0-060 Exam Dumps Questions & Answers

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data? (Choose three.)

• A.  Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
• B.  Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
• C.  Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
• D.  Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as input parameter and use RMAN to restore the data.
• E.  Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.

You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?

• A.  Location of the runtime area for DML and DDL Statements
• B.  Stack space
• C.  User session data
• D.  Location of a part of the runtime area for SELECT statements
• E.  Private SQL area

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

• A.  BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
• B.  BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
• C.  BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
• D.  BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
• E.  BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
• F.  BACKUP SPFILE SECTION SIZE 1M;
• G.  BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

• A.  All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
• B.  All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
• C.  Only DDL commands that resulted in the creation of new segments are logged.
• D.  All DDL commands are logged in the alert log file.
• E.  Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.

You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?

• A.  Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
  EXAM_RESULTS; connected as the OCP user.
• B.  Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
  OCP.EXAM_RESULTS; connected as SYSTEM.
• C.  Recovery the table sing Database Point In Time Recovery.
• D.  Recover the table using Automated Tablespace Point In Time Recovery.
• E.  Recover the table using traditional Tablespace Point In Time Recovery.