试题详情
- 多项选择题 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
关注下方微信公众号，在线模考后查看
热门试题