随笔分类 - 归档
摘要: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
阅读全文
摘要:You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery Area is specified as the destination for the archived
阅读全文
摘要: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
阅读全文
摘要:You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements
阅读全文
摘要: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
阅读全文
摘要:The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server:LOG_
阅读全文
摘要:You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario
阅读全文
摘要:You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 paramete
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)A. Database must be running in archivelog mode.B. Automatic undo manage
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:You issued the following commands to configure setting in RMAN;RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sb
阅读全文
摘要: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
阅读全文
摘要:Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)A.Flash recovery area must be definedB.Undo retention guarantee
阅读全文
摘要:You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LO
阅读全文
浙公网安备 33010602011771号