---

You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable：  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about the effect of the command（）
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.

---

出自：Oracle认证

显示答案