Oracle 11G OCP 1Z0-052 168

(168)You execute this command to drop the ITEM table, which has the primary key referred in the ORDER table:

SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;

Which two statements are true about the effect of the command? (Choose two.)

A.No flashback is possible to bring back the ITEM table.

B.The ORDER table is dropped along with the ITEM table.

C.The dependent referential integrity constraints in the ORDER table are disabled.

D.The dependent referential integrity constraints in the ORDER table are removed.

E.The table definition of the ITEM table and associated indexes are placed in the recycle bin.

答案:(A、D)
请使用浏览器的分享功能分享到微信等