6.8. Exam Essentials

Know how to recover a dropped table using Flashback Drop. Make sure you are aware of how the Recycle Bin works for dropped objects. You should be able to identify objects in the Recycle Bin. You should be familiar with how to manage the Recycle Bin and be able to perform a Flashback Drop recovery of a dropped object.

Know how to recover from user errors with Flashback Versions Query. Know how to perform a Flashback Versions Query using timestamp or SCN information. Be aware of how undo data is used with Flashback Versions Query and how to protect this data. You should also know how to identify data with pseudocolumns.

Be aware of how to perform a transactional level recovery using Flashback Transaction Query. Know how to use the Flashback Transaction Query to diagnose and analyze changes in the database. Make sure you understand how to identify specific information with Flashback Transaction Query and how to use Data Manipulation Language (DML) to undo a transaction.

Understand how to perform a Flashback Table operation. Know how to perform a Flashback Table operation with a timestamp or an SCN. Be aware of how undo data is used in Flashback Table and how to protect this data.