You executed the following command to drop a user:
DROP USER scott CASCADE;
Which two statement regarding the above command are correct? (Choose two.)
A.
All the objects of scott are moved to the Recycle Bin.
B.
Any objects in the Recycle Bin belonging to scott are purged.
C.
All the objects owned by scott are permanently dropped from the database.
D.
All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E.
Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
Explanation:
When you drop a user, any objects belonging to the user are not placed in the recycle bin and any objects in the recycle bin are purged.REF: Oracle(r) 10g Administrator Guide, 15-39
