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()
- ANo flashback is possible to bring back the ITEM table.
- BThe ORDER table is dropped along with the ITEM table.
- CThe dependent referential integrity constraints in the ORDER table are disabled.
- DThe dependent referential integrity constraints in the ORDER table are removed.
- EThe table definition of the ITEM table and associated indexes are placed in the recycle bin.