What will be the result of using the SQL> DROP USER SCOTT CASCADE; command?()
A.
The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and the objects that are already in the Recycle Bin are dropped.
B.
The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and all the objects in the Recycle Bin, belonging to the user Scott, are not dropped.
C.
The user, Scott, is dropped, all the objects in the Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin, belonging to the user, Scott, are not dropped.
D.
The user, Scott, is dropped, all the objects in Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin are dropped.