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?

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?

Accepted Answer

D. It recovers the structure, data, and indexes of the second emp table.

Answer

A. It recovers the structure, data, and indexes of the first emp table.

Answer

B. It recovers only the structure of the second emp table.

Answer

C. It returns an error because two tables with the same name exist in the recycle bin.

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…

Question

Options

How the community answered

Explanation

Topics

Community Discussion