随笔分类 -  归档

摘要:For which database operation would you need the database to be in the MOUNT state?A.renaming the control filesB.re-creating the control filesC.droppin 阅读全文
posted @ 2017-12-12 16:27 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
摘要:You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery Area is specified as the destination for the archived 阅读全文
posted @ 2017-12-11 13:14 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
摘要:You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode.Which two options 阅读全文
posted @ 2017-12-08 13:35 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
摘要:You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements 阅读全文
posted @ 2017-12-08 13:31 巴啦啦大魔王 阅读(153) 评论(0) 推荐(0)
摘要:Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode?A.The backup will consist of used data block 阅读全文
posted @ 2017-12-08 13:25 巴啦啦大魔王 阅读(112) 评论(0) 推荐(0)
摘要:The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server:LOG_ 阅读全文
posted @ 2017-12-08 13:19 巴啦啦大魔王 阅读(125) 评论(0) 推荐(0)
摘要:You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario 阅读全文
posted @ 2017-12-08 13:14 巴啦啦大魔王 阅读(68) 评论(0) 推荐(0)
摘要:You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 paramete 阅读全文
posted @ 2017-12-08 11:37 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0)
摘要:Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the databa 阅读全文
posted @ 2017-11-16 16:25 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
摘要:Which three components does the Scheduler use for managing tasks within the Oracle environment?(Choose three.)A. a jobB. a programC. a scheduleD. a PL 阅读全文
posted @ 2017-11-16 15:53 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0)
摘要:Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)A. Database must be running in archivelog mode.B. Automatic undo manage 阅读全文
posted @ 2017-11-16 14:54 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)
摘要:You want to track and store all transactional changes to a table over its lifetime. To accomplish thistask, you enabled Flashback Data Archive with th 阅读全文
posted @ 2017-11-16 14:38 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
摘要:Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is ru 阅读全文
posted @ 2017-11-16 13:39 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
摘要:While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space 阅读全文
posted @ 2017-11-16 11:02 巴啦啦大魔王 阅读(124) 评论(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 巴啦啦大魔王 阅读(83) 评论(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 巴啦啦大魔王 阅读(163) 评论(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 巴啦啦大魔王 阅读(162) 评论(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 巴啦啦大魔王 阅读(147) 评论(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 巴啦啦大魔王 阅读(108) 评论(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 巴啦啦大魔王 阅读(89) 评论(0) 推荐(0)