随笔分类 -  归档

摘要: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 阅读全文
posted @ 2017-11-15 16:58 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 15:58 巴啦啦大魔王 阅读(144) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 15:47 巴啦啦大魔王 阅读(122) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 15:16 巴啦啦大魔王 阅读(156) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 15:06 巴啦啦大魔王 阅读(115) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 13:53 巴啦啦大魔王 阅读(145) 评论(0) 推荐(0)
摘要:Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)A. configuri 阅读全文
posted @ 2017-11-15 13:45 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
摘要:As part of archiving the historical data, you want to transfer data from one database to anotherdatabase, which is on another server. All tablespaces 阅读全文
posted @ 2017-11-15 13:44 巴啦啦大魔王 阅读(151) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 11:39 巴啦啦大魔王 阅读(147) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 11:22 巴啦啦大魔王 阅读(173) 评论(0) 推荐(0)
摘要: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. 阅读全文
posted @ 2017-11-13 17:46 巴啦啦大魔王 阅读(114) 评论(0) 推荐(0)
摘要:In order to perform Flashback Transaction Query operations, which of these steps are required?(Choose all that apply.)A. Ensure that database is runni 阅读全文
posted @ 2017-11-13 15:16 巴啦啦大魔王 阅读(115) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-13 13:57 巴啦啦大魔王 阅读(94) 评论(0) 推荐(0)
摘要:True or false: you can perform an active database duplication when the database is inNOARCHIVELOG mode.A. TrueB. False 阅读全文
posted @ 2017-11-13 13:35 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 18:19 巴啦啦大魔王 阅读(72) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 18:09 巴啦啦大魔王 阅读(72) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 16:50 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 14:53 巴啦啦大魔王 阅读(128) 评论(0) 推荐(0)
摘要:Given the following RMAN commands, choose the option that reflects the order required to restoreyour currently operational ARCHIVELOG-mode database.A. 阅读全文
posted @ 2017-11-10 14:03 巴啦啦大魔王 阅读(190) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 18:04 巴啦啦大魔王 阅读(92) 评论(0) 推荐(0)