053试题 85 - 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.

参考答案 BC
解析
题目意思问，执行了drop user scott cascade。哪两个说法是正确的。
把相关对象放到回收站，是使用drop table之类的语句，A错误。
当删除一个用户后，该用户对应的在回收站的对象也会被删除掉。所以B正确。C正确。DE错误。

参考文档：

https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_9008.htm#SQLRF01811

DROP USER

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.

 

CASCADE

Specify CASCADE to drop all objects in the user's schema before dropping the user. You must specify this clause to drop a user whose schema contains any objects.

• If the user's schema contains tables, then Oracle Database drops the tables and automatically drops any referential integrity constraints on tables in other schemas that refer to primary and unique keys on these tables.

• If this clause results in tables being dropped, then the database also drops all domain indexes created on columns of those tables and invokes appropriate drop routines.

  See Also:

  Oracle Database Data Cartridge Developer's Guide for more information on these routines

• Oracle Database invalidates, but does not drop, the following objects in other schemas:

  • Views or synonyms for objects in the dropped user's schema

  • Stored procedures, functions, or packages that query objects in the dropped user's schema

• Oracle Database does not drop materialized views in other schemas that are based on tables in the dropped user's schema. However, because the base tables no longer exist, the materialized views in the other schemas can no longer be refreshed.

• Oracle Database drops all triggers in the user's schema.

• Oracle Database does not drop roles created by the user.

Caution:

Oracle Database also drops with FORCE all types owned by the user. See the FORCE keyword of DROP TYPE.

Restriction on Dropping Users 

You cannot drop a user whose schema contains a table that uses a flashback data archive. You must first disable use of the flashback data archive.

Examples

Dropping a Database User: Example If user Sidney's schema contains no objects, then you can drop sidney by issuing the statement:

DROP USER sidney; 

If Sidney's schema contains objects, then you must use the CASCADE clause to drop sidney and the objects:

DROP USER sidney CASCADE; 

END