This topic is big. Oracle has a lot of flashback technologies and the world "various" here means "all".
We have flashback table / transaction / database, and each of those has a lot of features. If your brain is not capable of memorizing all those syntax, do like me: understand very well the concepts, practice all and just keep in mind the path to the documentation so you can easily adapt some come during the exam.
Practice:
- Database
- Creating restore point and flashbacking
- Flashbacking to a SCN or TIME
- Table
- Flashback Query (SELECT AS OF)
- Flashback Version Query (VERSION BETWEEN)
- Flashback Drop (Recycle Bin)
- Transaction
- Enable supplemental logging
- Flashback Transaction Query (FLASHBACK_TRANSACTION_QUERY)
- DBMS_FLASHBACK
- Flashback using OEM 11g (easier than querying tables)
- Flashback Data Archive (Oracle Total Recall)
- Flashback Operations on Specific LOB Columns
Path to Documentation:
Advanced Application Developer's Guide -> 12 Using Oracle Flashback Technology
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!