One of the user sessions was terminated abnormally in the middle of a transaction. What does
Oracle database do to recover it?
A.
uses undo data for roll forward
B.
uses Flashback Log for recovery
C.
uses online redo logs to roll back
D.
uses undo data to roll back the transaction
E.
uses Recovery Manager (RMAN) to roll back
F.
uses the System Monitor (SMON) background process to perform instance recovery
Undo records are used to: Roll back transactions when a ROLLBACK statement is issued. Recover the database. Provide read consistency. Analyze data as of an earlier point in time by using Oracle Flashback Query.
DATA protection
When flashback is enabled or when there are guaranteed restore points, the background process RVWR writes flashback data to flashback database logs in the flash recovery area.