Which statement describes the outcome of the FLASHBACK command?

Prev Question
Next Question

The first DROP operation is performed on PRODUCTS table using the following command:
DROP TABLE products PURGE;
Then you performed the FLASHBACK operation by using the following command:
FLASHBACK TABLE products TO BEFORE DROP;
Which statement describes the outcome of the FLASHBACK command?

A.
It recovers only the table structure.

B.
It recovers the table structure, data, and the indexes.

C.
It recovers the table structure and data but not the related indexes.

D.
It is not possible to recover the table structure, data, or the related indexes.

Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9003.htm

Prev Question
Next Question

Leave a Reply

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