随笔分类 - OCP
OCP考试学习
摘要: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_CHEC
阅读全文
摘要:What command is used to reset a database to a previous incarnation?A. reset incarnationB. incarnation resetC. reset database to incarnationD. reset da
阅读全文
摘要:How many database instances are used during a database-duplication process?A. OneB. TwoC. ThreeD. FourE. Five The first is be the target database,and
阅读全文
摘要:Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?A. Set oracle_sid=orcl rman tar
阅读全文
摘要:When youre performing active database duplication, a backup of what kind is required?A. A current RMAN backup-set backup is required.B. No backup is r
阅读全文
摘要:Which command is used to begin a tablespace point-in-time recovery?A. Restore tablespaceB. Recover tablespaceC. Tablespace recoverD. Recover to timeE.
阅读全文
摘要:True or false: tablespace point-in-time recovery is possible only with RMAN.A. TrueB. False Tablespace point-in-time recovery has been done in Oracle
阅读全文
摘要:If a backup is expired, which of the following is true?A. It can never be used for a restore/recover operation.B. Oracle will remove the backup set pi
阅读全文
摘要:What information does the report schema command not provide? (Choose all that apply.)A. Size of the datafiles B. Size of the tempfilesC. Date of last
阅读全文
摘要:Why would you execute the report obsolete command?A. To list all backups that were no longer available for restore operationsB. To list all backups th
阅读全文
摘要:What is the result of this command? RMAN> Report need backup days 3;A. Lists all datafiles created in the last three days that are not backed up.B. Li
阅读全文
摘要:What does the minimize load database parameter mean when backing up a database?A. RMAN will attempt to make the backup run as fast as possible without
阅读全文
摘要:What does the output on this report indicate? RMAN> report need backup;RMAN retention policy will be applied to the commandRMAN retention policy is se
阅读全文
摘要:What is the impact of the results of the output of the following command?RMAN> report unrecoverable database;Report of files that need backup due to u
阅读全文
摘要:What view might you use to try to determine how long a particular backup will take?A. V$SESSION_EVENTB. V$SESSIONC. V$WAITSD. V$WAITSTATE. V$SESSION_L
阅读全文
摘要:In what view are you likely to see the following output?SID SERIAL# EVENT SECONDS_IN_WAIT121 269 RMAN backup & recovery I/O 2129 415 SQL*Net message f
阅读全文
摘要:What is the impact of the following backup if it exceeds the duration allowance? (Choose all thatapply.)Backup as compressed backupset duration 2:00 p
阅读全文
摘要:How long will this backup be allowed to run?Backup as compressed backupset duration 2:00 minimize load database ;A. 2 minutesB. 2 hoursC. 2 daysD. The
阅读全文
摘要:If a backup set is expired, what can you do to correct the problem?A. Change the retention criteria.B. Make the lost backup set pieces available to RM
阅读全文
摘要:What does it mean if a backup is expired?A. The backup set has exceeded the retention criteria set in RMAN and is eligible for removal.B. The backup s
阅读全文
浙公网安备 33010602011771号