Which two statements 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.
答案:(B、C)
解析:
DROP USER
使用该语句来移除数据库用户,也可以移除用户的对象.
在ASM集群中,以AS SYSASM方式验证的用户可以使用该语句从口令文件(是当前结点ASM实例本地的)移除用户.
当删除用户时,Oracle也会从回收站清除该用户方案中的所有对象.