you need to reverse the effects of the FLASHBACK TABLE command while ensuring that:

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:

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?

C.
Use ROLLBACK command with SCN 663571.

D.
Perform Flashback Transaction Query with SCN 663571.

E.
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was
at SCN 663571.

F.
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at
SCN 663571.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Jorge Andrade

Jorge Andrade

A) and B) are not answers and the correct answer is F)

Nauman Memon

Nauman Memon

F is correct answer