053 Question 85th

85.you executed the following command to drop a user:
DROP USER Scott CASCADE;
which a statements regarding the above command is correct? (Choose.)
a. All the objects of Scott is moved to the Recycle Bin.
b. Any objects in the Recycle Bin belonging to Scott is purged.
c. All the objects owned by Scott is permanently dropped from the database.
d. All the objects of Scott on the Recycle Bin must be purged before executing the DROP comma nd.
e. Any objects in the Recycle Bin belonging to Scott won't is affected by the above DR OP command.
Answer: BC

When you issue the DROP USER ... CASCADE command, the user and all the objects owned by the
User is permanently dropped from the database. Any objects in the Recycle Bin belonging to the
Dropped user is purged.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

053 Question 85th