Oracle
1Z0-047 · Question #46
1Z0-047 Question #46: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #46. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.