Oracle
1Z0-043 · Question #132
1Z0-043 Question #132: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-043 to reveal the answer and full explanation for question #132. The question stem and answer options stay visible for context.
Question
You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that: (a) No other user data in the database is affected. (b) The operation takes the minimum possible time Which option would you choose?
Options
- AUse ROLLBACK command with SCN 663571.
- BPerform Flashback Transaction Query with SCN 663571.
- CExecute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at
- DExecute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at
Unlock 1Z0-043 to see the answer
You've previewed enough free 1Z0-043 questions. Unlock 1Z0-043 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.