6.9. Review Questions

  1. Which underlying database technology is used by Flashback Drop, Flashback Table, and Flash back Versions Query to recover data?

    1. Redo logs

    2. Rollback segments

    3. Undo data

    4. Archive logs

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

    1. The Recycle Bin is a physical storage area of flashback dropped objects.

    2. The Recycle Bin is a logical container area of flashback dropped objects.

    3. The objects in the Recycle Bin are stored in the UNDO tablespace.

    4. The objects in the Recycle Bin are stored in the tablespace they were created in.

  3. What actions does the Flashback Drop process perform?

    1. Back up table only

    2. Back up table and indexes only

    3. Back up table and referential constraints only

    4. Back up table and dependent ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.