374.Which of the following statements are true regarding the Recycle Bin? (Choose all that apply.)
A. The Recycle Bin is a physical storage area for dropped objects.
B. The Recycle Bin is a logical container for dropped objects.
C. The Recycle Bin stores the results of a Flashback Drop operation.
D. The objects in the Recycle Bin are stored in the tablespace in which they were created.
Answer: BD
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12407737
The recycle bin is actually a data dictionary table containing information about dropped objects. Dropped tables and any associated objects such as indexes, constraints, nested tables, and the likes are not removed and still occupy space. They continue to count against user space quotas, until specifically purged from the recycle bin or the unlikely situation where they must be purged by the database because of tablespace space constraints.
Each user can be thought of as having his own recycle bin, because, unless a user has the SYSDBA
privilege, the only objects that the user has access to in the recycle bin are those that the user owns. A user can view his objects in the recycle bin using the following statement:
When you drop a tablespace including its contents, the objects in the tablespace are not placed in the recycle bin and the database purges any entries in the recycle bin for objects located in the tablespace. The database also purges any recycle bin entries for objects in a tablespace when you drop the tablespace, not including contents, and the tablespace is otherwise empty.
官网参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/tables.htm#sthref2315