Prev Question
Next Question

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.

Prev Question
Next Question

Leave a Reply

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