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 the effect of the command? (Choose two.)
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.
PURGE
If specified, the table and its dependent objects will be purged from the recycle bin and you will not be able to recover the table. If not specified, the table and its dependent objects are placed in the recycle bin and can be recovered later, if needed.
For example:
DROP TABLE customers PURGE;
This DROP TABLE statement would drop the table called customers and issue a PURGE so that the space associated with the customers table is released. In other words, the customers table is not placed into the recycle bin and, therefore, can not be recovered later if required.