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.
B