Exam 1z0-060 topic 2 question 34 discussion

Actual exam question from Oracle's 1z0-060

Question #: 34
Topic #: 2

The current system change number (SCN) for a live database is 663571.
You decide to use the FLASHBACK TABLE statement to flash back the CUSTOMERS table to SCN 662116.
After flashing back the CUSTOMERS table, you query it and decide to undo the effects of the FLASHBACK TABLE command.
Which is the fastest way to do this?

A. Execute the RMAN RECOVER BLOCK command by specifying the table name and SCN 663571 because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.
B. Execute another FLASHBACK TABLE statement to restore the CUSTOMERS table to SCN 663571.
C. Perform table point-in-time recovery because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.
D. Perform tablespace point-in-time recovery because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.

Show Suggested Answer

Suggested Answer: B 🗳️

by Blade69 at Jan. 5, 2022, 7:09 p.m.

Comments

Submit Cancel

Nilendu

3 years ago

I think correct answer is C.

upvoted 1 times

...

Blade69

3 years, 5 months ago

https://docs.oracle.com/database/121/SQLRF/statements_9013.htm#SQLRF01802

upvoted 1 times

...