You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about theeffect of the command()
- A、No flashback is possible to bring back the ITEM table.
- B、The ORDERS table is dropped along with the ITEM table.
- C、The dependent referential integrity constraints in the ORDERS table are disabled.
- D、The dependent referential integrity constraints in the ORDERS table are removed.
- E、The table definition of the ITEM table and associated indexes are placed in the recycle bin
正确答案:A,D
答案解析:有

微信扫一扫手机做题