Which statement is true regarding the above FLASHBACK operation?

Evaluate the following SQL statements in the given order: DROP TABLE dept; CREATE
TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10)); DROP
TABLE dept; FLASHBACK TABLE dept TO BEFORE DROP; Which statement is true
regarding the above FLASHBACK operation?

Evaluate the following SQL statements in the given order: DROP TABLE dept; CREATE
TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10)); DROP
TABLE dept; FLASHBACK TABLE dept TO BEFORE DROP; Which statement is true
regarding the above FLASHBACK operation?

A.
It recovers only the first DEPT table.

B.
It recovers only the second DEPT table.

C.
It does not recover any of the tables because FLASHBACK is not possible in this case.

D.
It recovers both the tables but the names would be changed to the ones assigned in the
RECYCLEBIN.



Leave a Reply 0

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