SCN
Timestamp
Named recovery point
Transaction ID
Session ID
第1题:
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()
第2题:
You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database?()
第3题:
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
第4题:
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()
第5题:
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?()
第6题:
Flashback Database relies on which technologies to recover to a point in time?()
第7题:
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?()
第8题:
A. point-in-time recovery
B. execute the ROLLBACK command with transaction number
C. flashback the database to before the transaction was committed
D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
第9题:
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()
第10题:
You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()