32題、Examine the command and its output:

SQL> DROP TABLE EMPLOYEE;

SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin;

RECYCLE_NAME     ORIGINAL_NAME     TYPE

--------------------------------------------------------------------------------------------------------------

binsgk31sj/3akk5hg3j21kl5j3d==$0    EMPLOYEE

TABLE You then successfully execute the command:

SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;

Which two statements are true?

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.

Answer: B,D

(解析：閃回表以后，除了引用其他表的引用完整性約束之外，所有約束在表被閃回之后自動(dòng)恢復(fù)，所以 A 答案是

錯(cuò)的;索引是自動(dòng)閃回;觸發(fā)器也會(huì)自動(dòng)閃回，而且名字被改變?yōu)椋築IN$3JNiRebHSD+sRbnNmf45dQ==$0，跟索

引的處理方式一樣;閃回表時(shí)結(jié)構(gòu)和數(shù)據(jù)都會(huì)恢復(fù)回來(lái)。)