Oracle
1Z0-047 · Question #46
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…
The correct answer is B. It recovers only the second DEPT table. See the full explanation below for the reasoning.
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?
Options
- AIt recovers only the first DEPT table.
- BIt recovers only the second DEPT table.
- CIt does not recover any of the tables because FLASHBACK is not possible in this case.
- DIt recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN.
How the community answered
(36 responses)- A6% (2)
- B83% (30)
- C8% (3)
- D3% (1)
Community Discussion
No community discussion yet for this question.