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 *