CMS专题
单选题Flashback Database relies on which technologies to recover to a point in time？（）AFlashback Data ArchiveBFlashback logs in the flash recovery areaCFlashbUndo tablespaceDRMAN command lineENone of the above
题目
Flashback Data Archive
Flashback logs in the flash recovery area
FlashbUndo tablespace
RMAN command line
None of the above
相似问题和答案
第1题：
A. set Flash Recovery Area
B. enable Flashback logging
C. create FLASHBACK tablespace
D. start the database in the ARCHIVELOG mode
E. start the database in the NOARCHIVELOG mode
第2题：
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）
- A、 DBWn
- B、 RECO
- C、 RVWR
- D、 LGWR
正确答案:C
第3题：
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）
A. Check the alert log file
B. Query the V$FLASHBACK_DATABASE_LOG view
C. Query the V$RECOVERY_FILE_DEST_SIZE view
D.Query the V$FLASHBACK_DATABASE_STAT view
E. Check the value assigned for the UNDO_RETENTION parameter
第4题：
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）
- A、Check the alert log file
- B、Query the V$FLASHBACK_DATABASE_LOG view
- C、Query the V$RECOVERY_FILE_DEST_SIZE view
- D、Query the V$FLASHBACK_DATABASE_STAT view
- E、Check the value assigned for the UNDO_RETENTION parameter
正确答案:B
第5题：
Flashback Database relies on which technologies to recover to a point in time？（）
- A、 Flashback Data Archive
- B、 Flashback logs in the flash recovery area
- C、 FlashbUndo tablespace
- D、 RMAN command line
- E、 None of the above
正确答案:B
第6题：
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）
- A、 Flashback logs are not archived.
- B、 Flashback logs are maintained in redo log files.
- C、 Flashback logs are maintained in the Flash Recovery Area.
- D、 Flashback logs are used to maintain Flashback Database related errors.
- E、 Flashback logs need to be cleared manually after you disable Flashback Database.
正确答案:A,C
第7题：
Your Oracle Database 10g is online when you execute the following statement： SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF； What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）
- A、 The database does not record flashback logs for MY_TABLESPACE
- B、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
- C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
- D、 None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
正确答案:A
第8题：
A. All the related indexes and views are automatically dropped
B. The flashback drop feature can recover only the table structure
C. Only the related indexes are dropped whereas views are invalidated
D. The flashback drop feature can recover both the table structure and its data
第9题：
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）
- A、 V$DATABASE
- B、 V$FLASHBACK_DATABASE_STAT
- C、 V$FLASHBACK_DATABASE_LOG
- D、 V$RECOVERY_FILE_DEST
正确答案:B
第10题：
In which case would you use the Flashback Database feature to perform a recovery？（）
- A、to recover a dropped tablespace
- B、to recover data from a truncated table
- C、to recover a data file that has been shrunk
- D、to recover a database to the state that existed before the RESETLOGS operation
正确答案:B