Oracle OCP 1Z0-053 Q85(DROP USER CASCADE)
85.You executed the following command to drop a user:
DROP USER scott CASCADE;
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.
Answer: BC
删除schema的时候，注意回收站中被删除用户的对象也会一并删除
参考：http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_9008.htm#SQLRF01811
DROP USER scott CASCADE;
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.
Answer: BC
删除schema的时候，注意回收站中被删除用户的对象也会一并删除
参考：http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_9008.htm#SQLRF01811
Purpose
Use the DROP USER statement to remove a database user and optionally remove the user's objects.
In an Oracle Automatic Storage Management (Oracle ASM) cluster, a user authenticated AS SYSASM can use this clause to remove a user from the password file that is local to the Oracle ASM instance of the current node.
When you drop a user, Oracle Database also purges all of that user's schema objects from the recycle bin.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2062600/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
