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.
Explanation:
Oracle Database 10g introduces a new feature for dropping tables. When you drop a table, the database does not immediately release the space associated with the table. Rather, the database renames the table and places it in a recycle bin, where it can later be recovered with the FLASHBACK TABLE statement if you find that you dropped the table in error. If you want to immediately release the space associated with the table at the time you issue the DROP TABLE statement, then include the PURGE clause as follows. DROP TABLE employees PURGE; Specify PURGE only if you want to drop the table and release the space associated with it in a single step. If you specify PURGE, then the database does not place the table and its dependent objects into the recycle bin. NOTE: You cannot roll back a DROP TABLE statement with the PURGE clause, and you cannot recover the table if you drop it with the PURGE clause. This feature was not available in earlier releases.
http://stackoverflow.com/questions/7713432/difference-between-drop-and-drop-purge-in-oracle