Oracle
1Z0-043 · Question #43
You work as a database administrator at certkiller.com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been…
The correct answer is D. perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary. See the full explanation below for the reasoning.
Question
You work as a database administrator at certkiller.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?
Options
- Aperform point-in-time recovery
- Bperform a Flashback Table operation to restore the table to the state it was in two days ago
- Cperform a Flashback Database operation to restore the database to the state it was in two days ago
- Dperform Flashback Versions Query and Flashback Transaction Query to determine all the necessary
How the community answered
(14 responses)- A14% (2)
- B7% (1)
- C7% (1)
- D71% (10)
Community Discussion
No community discussion yet for this question.