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?

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.



Leave a Reply 2

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


User

User

See Table structure, use:

SELECT COLUMN_NAME, DATA_TYPE
FROM ALL_TAB_COLUMNS WHERE TABLE_NAME=’…’

doris

doris

cannot rollback after using PURGE