OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

3.10. Answers to Review Questions

1. C. Non-critical losses have little impact on database operations if resolved properly.

2. B. Temporary tablespaces are responsible for storing temporary or sort segments. These are used in the sorting of select statements or in building indexes.

3. C. A missing tempfile can be re-created with the create tablespace command. Because the tempfile is locally managed and contains no permanent data, no restoring or recovering is needed. Therefore recovery can occur quickly with minimal impact to database operations.

4. C, D. A missing temporary tablespace can be quickly reassigned with the command ALTER DATABASE to an existing temporary tablespace if one is available. If one is not available, you will need to run CREATE TEMPORARY ...