- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
11.
Which command would you use to determine what database backups are currently available for restore?
- A.LIST DATABASE BACKUP;
- B.REPORT DATABASE BACKUP;
- C.LIST BACKUP OF DATABASE;
- D.LIST SUMMARY BACKUP;
- E.REPORT BACKUP OF DATABASE;
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The LIST BACKUP OF DATABASE command provides information on all database backups that are available for restore via RMAN. |
12.
What command would you use to ensure that backup records in the control file are
pointing to actual physical files on the backup media?
- A.CROSSCHECK
- B.LIST BACKUP
- C.YCONFIRM
- D.RESYNC
- E.BACKUP VALIDATE
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The CROSSCHECK command is used to validate all RMAN-related metadata with associated physical backups on backup media. |
13.
You have backed up your database twice without connecting to the recovery catalog.
What command do you issue to transfer the control-file metadata to the recovery catalog?
- A.SYNCH CATALOG
- B.RESYNC CATALOG
- C.REPLICATE CATALOG
- D.UPDATE CATALOG
- E.RESTORE CATALOG
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The RESYNC CATALOG command is used to synchronize the recovery catalog with the database control file. |
14.
You want to make sure that your database backup does not exceed 10 hours in length.
What command would you issue that would meet this condition?
- A.BACKUP DATABASE PLUS ARCHIVELOG;
- B.BACKUP DATABASE PLUS ARCHIVELOG UNTIL TIME '10:00';
- C.BACKUP DATABASE PLUS ARCHIVELOG TIMEOUT '10:00';
- D.BACKUP DATABASE PLUS ARCHIVELOG DURATION '10:00';
- E.BACKUP DATABASE PLUS ARCHIVELOG TIMEOUT 10:00;
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The DURATION command is used to limit the overall time of a database backup. |
15.
You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you
have an automated cross-check script that also does a DELETE EXPIRED BACKUPSET com-
mand. You have restored all the backup set pieces from tape. What command would you
use to get those backup set pieces registered in the recovery catalog and the control file of
the database again?
- A.REGISTER DATABASE
- B.RECOVER CATALOG
- C.LOAD BACKUPSET
- D.SYNCH METADATA
- E.CATALOG START WITH
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| The CATALOG command is used to load backup set pieces that do not already exist into the recovery catalog or the control file. |
|
|
||||||||||||||||||||||||||||
