摘要: Which mode of database shutdown requires an instance recovery at the time of the next database startup?A.ABORTB.NORMALC.IMMEDIATED.TRANSACTIONAL 数据库在关 阅读全文
posted @ 2017-11-15 17:47 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0) 编辑
摘要: View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:RMAN> BACKUP DATABASE FILE 阅读全文
posted @ 2017-11-15 17:44 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0) 编辑
摘要: Which two statements are true about encrypting RMAN backup? (Choose two.)A. The transparent encryption of backups uses the encryption walletB. The dat 阅读全文
posted @ 2017-11-15 17:41 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0) 编辑
摘要: Which option is best practice for creating a recovery catalog owner in the catalog database? A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to t 阅读全文
posted @ 2017-11-15 17:40 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0) 编辑
摘要: The database is running in the ARCHIVELOG mode. It has three redo log groups with one membereach. One of the redo log groups has become corrupted. You 阅读全文
posted @ 2017-11-15 17:39 巴啦啦大魔王 阅读(75) 评论(0) 推荐(0) 编辑
摘要: In Recovery Manager (RMAN), you are taking image copies of the data files of your productiondatabase and rolling them forward at regular intervals. Yo 阅读全文
posted @ 2017-11-15 17:37 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0) 编辑
摘要: Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?A. New chan 阅读全文
posted @ 2017-11-15 17:34 巴啦啦大魔王 阅读(178) 评论(0) 推荐(0) 编辑
摘要: Your database is running in ARCHIVELOG mode.One of the data files,USERDATA01.dbf,inthe USERS tablespace is damaged and you need to recover the file un 阅读全文
posted @ 2017-11-15 17:20 巴啦啦大魔王 阅读(158) 评论(0) 推荐(0) 编辑
摘要: You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the 阅读全文
posted @ 2017-11-15 17:17 巴啦啦大魔王 阅读(99) 评论(0) 推荐(0) 编辑
摘要: You issued the following commands to configure setting in RMAN;RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sb 阅读全文
posted @ 2017-11-15 17:16 巴啦啦大魔王 阅读(157) 评论(0) 推荐(0) 编辑
摘要: You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What 阅读全文
posted @ 2017-11-15 17:14 巴啦啦大魔王 阅读(141) 评论(0) 推荐(0) 编辑
摘要: Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)A.Flash recovery area must be definedB.Undo retention guarantee 阅读全文
posted @ 2017-11-15 17:13 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0) 编辑
摘要: You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed u 阅读全文
posted @ 2017-11-15 17:09 巴啦啦大魔王 阅读(121) 评论(0) 推荐(0) 编辑
摘要: You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two sce 阅读全文
posted @ 2017-11-15 17:07 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0) 编辑
摘要: View the Exhibit and note the contents of V$DIAG_INFO.Which statement is true about the ADR? A. The text alert log file will be available in Diag Trac 阅读全文
posted @ 2017-11-15 17:06 巴啦啦大魔王 阅读(77) 评论(0) 推荐(0) 编辑
摘要: You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LO 阅读全文
posted @ 2017-11-15 17:04 巴啦啦大魔王 阅读(83) 评论(0) 推荐(0) 编辑
摘要: A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL> CREATE DISKGROUP 阅读全文
posted @ 2017-11-15 17:03 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0) 编辑
摘要: The EMP table has some discrepancy in data entry with a particular employee ID. You execute thequery as shown in the Exhibit to retrieve all versions 阅读全文
posted @ 2017-11-15 17:01 巴啦啦大魔王 阅读(69) 评论(0) 推荐(0) 编辑
摘要: Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed 阅读全文
posted @ 2017-11-15 16:59 巴啦啦大魔王 阅读(98) 评论(0) 推荐(0) 编辑
摘要: 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 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0) 编辑