Which of the following statements are true regarding the Recycle Bin?

Which of the following statements are true regarding the Recycle Bin? (Choose all that
apply.)

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Jake from SF

Jake from SF

B and D are correct:

https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm

7.4.1 What is the Recycle Bin?
The recycle bin is a logical container for all dropped tables and their dependent objects. When a table is dropped, the database will store the table, along with its dependent objects in the recycle bin so that they can be recovered later. Dependent objects which are stored in the recycle bin include indexes, constraints, triggers, nested tables, LOB segments and LOB index segments.

Dropped tables and any associated objects such as indexes, constraints, nested tables, and the likes are not removed and still occupy space.