Uses undo data for roll forward
Uses Flashback Log for recovery
Uses online redo logs to roll back
Uses undo data to roll back the transaction
Uses Recovery Manager (RMAN) to roll back
Uses the System Monitor (SMON) background process to perform instance recovery
第1题:
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? ()
第2题:
You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, SupportCenter, asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows?()
第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题:
Which three statements are true about Flashback Database?()
第5题:
You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()
第6题:
In which case would you use the Flashback Database feature to perform a recovery?()
第7题:
You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()
第8题:
You work as a database administrator for Supportcenter.cn. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()
第9题:
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()
第10题:
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()