6.10. Answers to Review Questions

  1. C. All the Flashback Technologies, with the exception of the Flashback Database, utilize the undo data to recover objects.

  2. B, D. The Recycle Bin is a logical container of flashback dropped objects. The objects in the Recycle Bin are stored in the tablespace they were created in.

  3. D. The Flashback Drop process is responsible for backing up tables and their dependent objects.

  4. E. Only non-partitioned index-organized tables are protected by the Recycle Bin. Non-system and locally managed tablespaces are stored in the Recycle Bin. Referential constraints are not stored in the Recycle Bin. DML or DDL cannot be performed against objects in the Recycle Bin.

  5. A. The command DROP USER user CASCADE drops the user and the database ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial