- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
66.
What command is used to reset a database to a previous incarnation?
- A.RESET INCARNATION
- B.INCARNATION RESET
- C.RESET DATABASE TO INCARNATION
- D.RESET DATABASE INCARNATION
- E.RESET DATABASE INCARNATION NUMBER
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The RESET DATABASE TO INCARNATION command is used to reset the database incarnation |
67.
What view would you use to determine if a given tablespace is fully self-contained for
the execution of a tablespace point-in-time recovery?
- A.TS_CHECK
- B.TPITR_CHECK
- C.TS_PITR_CHECK
- D.CHECK_TSPITR
- E.PITR_TS_CHECK
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| 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. |
68.
Which of the following is true with respect to multitenant backups?
- A.You cannot use RMAN to restore a PDB.
- B.You cannot use Oracle Data Pump if the source database is a PDB.
- C.Oracle Data Pump can export from only a single PDB at a time.
- D.You cannot use RMAN to back up an entire CDB database.
- E.All of the above are false statements.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| 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. |
69.
When performing a database duplication, which DUPLICATE DATABASE parameter
would you set to ensure that the online redo logs are created in the correct location?
- A.LOG_FILE_NAME_CONVERT
- B.CONVERT_LOG_FILE_NAME
- C.FILE_NAME_CONVERT_LOG
- D.REDO_LOG_FILE_NAME_CONVERT
- E.LOGFILE_CONVERT_DIRECTORY
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| 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. |
70.
Which command would correctly start a TSPITR of the USERS tablespace?
- A.recover tablespace users
until time '10/06/2013:22:42:00' auxiliary 'c:\oracle\auxiliary'; - B.recover tablespace users
time '10/06/2013:22:42:00' auxiliary destination 'c:\oracle\auxiliary'; - C.recover tablespace users
to point-in-time '10/06/2013:22:42:00' auxiliary destination 'c:\oracle\auxiliary'; - D.recover tablespace users
except time '10/06/2013:22:42:00' auxiliary destination 'c:\oracle\auxiliary'; - E.recover tablespace users
until time '10/06/2013:22:42:00' auxiliary destination 'c:\oracle\auxiliary';
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| 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. |
|
|
||||||||||||||||||||||||||||
