Upgrade Oracle DBA 11g to Oracle Database 12c — Question 43

Examine the command and its output:
SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin;

RECYCLE_NAMEORIGINAL_NAMETYPE -
-------------------------------------------------------------------------------------------------------------- binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE
You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;
Which two statements are true?

Answer options

• A. It flashes back the employee table and all the constraints associated with the table.
• B. It automatically flashes back all the indexes on the employes table.
• C. It automatically flashes back any triggers defined on the table.
• D. It flashes back only the structure of the table and not the data.
• E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

Correct answer: A, C

Explanation

Answer A is correct because when you flash back a table, all associated constraints are also restored. Answer C is also correct since triggers defined on the table will be automatically restored with the flashback. The other options are incorrect because indexes are not automatically restored (B), the structure and data are both restored (D), and existing data in the original table is not lost (E).