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

3.9. Review Questions

1. Which of the following statements is true about non-critical losses?

   1. Non-critical losses require media recovery.

   2. Non-critical losses have a severe impact on database operations.

   3. Non-critical losses can be resolved quickly with little impact to database operations.

   4. Non-critical losses require the use of the RECOVER command.

2. Which of the following statements is true about temporary tablespaces?

   1. Temporary tablespaces most often contain some permanent objects.

   2. Temporary tablespaces are responsible for storing temporary or sort statements.

   3. Temporary tablespaces must be recovered with the RECOVER command.

   4. Temporary tablespaces cannot be managed locally.

3. Why is a missing tempfile considered a non-critical recovery situation?

   1. The tempfile ...