Which statement describes the outcome of the FLASHBACK …

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?

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



Leave a Reply 0

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