You work as a database administrator at Pass4sures.com. You are working in an online
transaction processing (OLTP) environment. You realize that the salary for an employee,
John, has been accidentally modified in the EMPLOYEES table. Two days ago, the data was
in the correct state. Flashback logs generated during last two days are available in the flash
recovery area. Which option would you choose to bring the data to the correct state while
ensuring that no other data in the same table is affected?
A.
perform point-in-time recovery
B.
perform a Flashback Table operation to restore the table to the state it was in two days
ago
C.
perform a Flashback Database operation to restore the database to the state it was in two
days ago
D.
perform Flashback Versions Query and Flashback Transaction Query to determine all the
necessary undo SQL statements, and then use them for recovery