Multiple choice technology databases

Before making a tablespace read only, which of the following conditions must be met

  1. The tablespace must be online

  2. The tablespace must not contain any active rollback segments

  3. he tablespace must not be involved in an open backup

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Before making a tablespace read-only, it must be online (not offline), cannot contain active rollback segments, and must not be in an open backup state. These are prerequisite conditions enforced by Oracle to ensure data consistency and recoverability. All three conditions must be satisfied.

Keep practicing — related questions