Oracle
1Z0-063 · Question #136
1Z0-063 Question #136: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-063 to reveal the answer and full explanation for question #136. The question stem and answer options stay visible for context.
Question
Examine the commands: SQL> ALTER SESSION SET RECYCLBIN = ON; Session altered. SQL> DROP TABLE emp; --(First EMP table) Total dropped. SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) ); Table created. You then execute multiple INSERT statements to insert rows into EMP table and drop the table again: SQL> DROP TABLE emp; -- (Second EMP table) Table dropped. SQL> FLASHBACK TABLE emp TO BEFORE DROP; Which statement is true about the FLASHBACK command?
Options
- AIt recovers the structure, data, and indexes of the first emp table.
- BIt recovers only the structure of the second emp table.
- CIt returns an error because two tables with the same name exist in the recycle bin.
- DIt recovers the structure, data, and indexes of the second emp table.
Unlock 1Z0-063 to see the answer
You've previewed enough free 1Z0-063 questions. Unlock 1Z0-063 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.