Answers to Review Questions - OCP: Oracle Database 12c Administrator Certified Professional - page 673

7. C. The TS_PITR_CHECK view is used to determine if a given tablespace (or tablespaces)
can be independently transported or if there are other dependencies that will require
the transport of additional tablespaces.
8. C. To export from a CDB, you have to log into a specific PDB and export that PDB.
Since you log in using the Oracle Net service name, that run of Oracle Data Pump can
export only a single PDB.
9. A. The correct answer is LOG_FILE_NAME_CONVERT . This setting will direct RMAN to
the directory in which it should create the online redo logs.
10. E. The correct command is shown in option E. You would issue the RECOVER TABLESPACE
command and list the tablespaces to be recovered. You would then use the UNTIL TIME
parameter to define the point in time to restore the tablespace to. Finally, you would
define the location for the auxiliary database instance with the AUXILIARY DESTINATION
parameter.
11. B. Any database to be duplicated in active mode must be in ARCHIVELOG mode.
12. B. This error message alludes to the fact that there is no backup of the database avail-
able to perform TSPITR. A backup before the point in time of the recovery is required
to perform TSPITR.
13. A, B. The database must be in ARCHIVELOG mode to perform a TSPITR. Addition-
ally, you must have a backup of the database that occurred at a point in time before the
point in time to which you want to perform the TSPITR.
14. C. Use the TS_PITR_OBJECTS_TO _ BE_DROPPED view to determine which objects will be
lost as a result of the pending tablespace point-in-time recovery operation. To preserve
the objects, you will want to export them before the TSPITR and import them after
the recovery is complete with the Oracle Data Pump or Imp/Exp utility.
15. B. If there is a constraint between two objects in two different tablespaces, you must
perform a TSPITR between the two tablespaces. As an alternative, you could disable
or drop the constraint. You may not be able to reenable the constraint with validation
after the TSPITR, however.
16. D. The DB_FILE_NAME_CONVERT parameter is used to define the location in which the
data files for the auxiliary-database data files should be created.
17. D. The second RECOVER TABLESPACE command will fail because it is trying to perform
a recovery to a point in time before the time to which the tablespace was recovered
during the first recovery.
18. B. An active database duplication requires that you have access to the target database
that is the source of the duplication process. If you have not connected to that data-
base, then the attempt to perform an active database duplication will fail.