随笔分类 - OCP
OCP考试学习
摘要：Why would you run the delete obsolete command? (Choose all that apply.)A. To remove missing backup set pieces physically from diskB. To remove metadat
阅读全文
摘要：You run the following commands:RMAN> list expired backup; RMAN> delete expired backup;What will happen to the backup set pieces associated with the ba
阅读全文
摘要：You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have anautomated cross-check script that also does a delete ex
阅读全文
摘要：You want to make sure that your database backup does not exceed 10 hours in length. Whatcommand would you issue that would meet this condition?A. back
阅读全文
摘要：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
阅读全文
摘要：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. crosscheckB.
阅读全文
摘要：Which command would you use to determine what database backups are currently available forrestore?A. list database backup;B. report database backup;C.
阅读全文
摘要：David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the contr
阅读全文
摘要：Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?A. shutd
阅读全文
摘要：What will be the end result of this set of RMAN commands?shutdown abortstartup mountrestore datafile 4 until time ,,09/30/2008:15:00:00; recover dataf
阅读全文
摘要：If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status ofMEDIA_CORRUPT, what RMAN command would you run to correct the problem?A. re
阅读全文
摘要：You have backed up your database using image copies. You have lost the SYSTEM tablespace and need to restart your database as quickly as possible. Wha
阅读全文
摘要：You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP.You want to"roll back" the data in the USERS tablespace to the w
阅读全文
摘要：Which of the following does the recover command not do? A. Restore archived redo logs.B. Apply archived redo logs.C. Restore incremental backups.D. Ap
阅读全文
摘要：Which of the following are valid until command options when attempting point-in-time recovery inRMAN? (Choose all that apply.)A. until timeB. until ch
阅读全文
摘要：Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:RESTORE CONTR
阅读全文
摘要：What is the correct order of the following commands if you wanted to restore datafile 4, which wasaccidentally removed from the file system?A. sql 'al
阅读全文
摘要：You need to restore your database back to 9/30/2008 at 18:00. In what order would you run thefollowing commands to compete this task?A. restore contro
阅读全文
摘要：True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.A. TrueB. False There is no equivalent RMAN co
阅读全文
摘要：You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-fileautobackups. Which files are not backed up during the RMAN ba
阅读全文
浙公网安备 33010602011771号