Evaluate the following SQL statements in the given order

mhmadesk

Save to bookmark

2022-07-19

479

Medium

Evaluate the following SQL statements in the given order.
Which statement is true regarding the above FLASHBACK operation?

DROP TABLE dept;
CREATE TABLE dept
(deptno NUMBER(3) PRIMARY KEY,
deptname VARCHAR2(10));
DROP TABLE dept;
FLASHBACK TABLE dept TO BEFORE DROP;

It recovers only the first DEPT table
It recovers only the second DEPT table
It does not recover any of the tables because FLASHBACK is not possible in this case
It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN

Database, MCQ Questions, Database MCQ-questions,

mhmadesk

2022-07-19

need an explanation for this answer? contact us directly to get an explanation for this answer

(b).It recovers only the second DEPT table

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)