随笔分类 - 归档
摘要:Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?(Choose three.)A. Alert log fi
阅读全文
摘要:You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the b
阅读全文
摘要:What two are the prerequisites for enabling Flashback Database? (Choose two)A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT
阅读全文
摘要:The database is configured in ARCHIVELOG mode and regular complete database backups are taken.The loss of which two types of files may require a recov
阅读全文
摘要:You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are c
阅读全文
摘要:Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)A.It is a copy or a subs
阅读全文
摘要:Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)A. configuri
阅读全文
摘要:As part of archiving the historical data, you want to transfer data from one database to anotherdatabase, which is on another server. All tablespaces
阅读全文
摘要:Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.You are informed that some
阅读全文
摘要:Identify the scenarios in which the RMAN CROSSCHECK comm and is useful. (Choose all that apply.)A.To check that the obsolete backups are deleted from
阅读全文
摘要:To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?A. TRUNCATE the archive table.B.
阅读全文
摘要:In order to perform Flashback Transaction Query operations, which of these steps are required?(Choose all that apply.)A. Ensure that database is runni
阅读全文
摘要:Which of the following restrictions are not true with respect to tablespace point-in-time recovery?(Choose all that apply.)A. The target database must
阅读全文
摘要:True or false: you can perform an active database duplication when the database is inNOARCHIVELOG mode.A. TrueB. False
阅读全文
摘要: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 output on this report indicate? RMAN> report need backup;RMAN retention policy will be applied to the commandRMAN retention policy is se
阅读全文
摘要: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 are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-fileautobackups. Which files are not backed up during the RMAN ba
阅读全文
摘要:Given the following RMAN commands, choose the option that reflects the order required to restoreyour currently operational ARCHIVELOG-mode database.A.
阅读全文
摘要:Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups
阅读全文
浙公网安备 33010602011771号