Free Oracle 1z1-074 Exam Dumps Questions & Answers

Which two are true about tables recovered by using the RMAN RECOVER TABLE command or the command itself, starting from Oracle Database 12c Release 2? (Choose two.)

• A.  They must be un-partitioned tables
• B.  They can be recovered by RMAN without an AUXILIARY instance
• C.  An AUXILIARY instance is started only if there is sufficient disk space
• D.  They may be recovered to a different schema in the same pluggable database (PDB)
• E.  They may be recovered to a schema in a different PDB

Which two statements are true about clean restore points in a regular PDB? (Choose two.)

• A.  They are created as guaranteed restore points
• B.  They can be created only if shared undo is enabled
• C.  They require a clone instance to be created when used in a PDB flashback operation
• D.  They can be created only for a PDB in the mount state
• E.  They can be created for a PDB when connected to either the PDB or to the root
• F.  They require backups to be restored when used in a PDB flashback operation

You receive complaints about poor performance in an Oracle 12c database while long running queries execute.
You must obtain statistics such as elapsed time, CPU time, number of reads and writes, I/O wait time, and other wait times for each step of each execution plan to help diagnose the problem during query execution.
How would you achieve this?

• A.  by viewing Active Reports for that time period
• B.  by enabling tracing for sessions that run these queries
• C.  by enabling SQL trace for each query
• D.  by running the Automatic Workload Repository (AWR) report for that time period
• E.  by running the Active Session History (ASH) report for that time period

You create a refreshable copy PDB, PDB_COPY, from the PDB_ORG PDB by using the REFRESH MODE EVERY 5 MINUTES clause.
What happens every five minutes?

• A.  An automatic refresh is done provided PDB_COPY is in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.
• B.  PDB_COPY is automatically closed provided there is no ongoing transaction in PDB_ORG and then reopened as read-only after the refresh is complete.
• C.  PDB_COPY'S state is automatically changed to read-only and then reopened as read-write after the refresh is complete.
• D.  PDB_COPY'S state is automatically changed to read-write and back to read-only after the refresh is complete.
• E.  An automatic refresh is done provided PDB_COPY is closed; otherwise the refresh is differed and attempted again after five minutes.

Your CDB is in ARCHIVELOG mode and has an application container with a container PDB. A backup exists for the CDB.
When you connect to the container PDB and try to execute a query, you get an error that a SYSTEM data file is missing in the container PDB.
You want to use the RMAN RESTORE DATABASE and RECOVER DATABASE commands to perform the recovery.
Examine these actions:
* Connect to CDB$ROOT and execute SHUTDOWN ABORT and STARTUP MOUNT.
* Connect to the application container and execute SHUTDOWN ABORT.
* Connect to the application container and execute ALTER PLUGGABLE DATABASE CLOSE ABORT.
Which option correctly lists the actions that you must execute before performing the recovery?

• A.  only 2
• B.  1 and 3
• C.  1 and 2
• D.  only 3