Oracle Database 12c: Advanced Administration — Question 43

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?

Answer options

• A. It recovers the structure, data, and indexes of the first emp table.
• B. It recovers only the structure of the second emp table.
• C. It returns an error because two tables with the same name exist in the recycle bin.
• D. It recovers the structure, data, and indexes of the second emp table.

Correct answer: A

Explanation

The correct answer is A because the FLASHBACK command can retrieve the first version of the EMP table from the recycle bin, which includes its structure, data, and indexes. The other options are incorrect as they misrepresent the behavior of the FLASHBACK command regarding the tables present in the recycle bin.