Multiple choice

When should one back up a read-only tablespace?

  1. During regular backup window

  2. Prior to placing the tablespace into read-only mode

  3. Immediately after placing the tablespace into read-only mode

  4. Prior to creating a new tablespace

  5. Prior to altering the database structure

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A read-only tablespace should be backed up immediately after being placed in read-only mode. Once read-only, the tablespace cannot change, so this single backup suffices until the tablespace returns to read-write mode. Backing up after the mode change ensures consistency.

Keep practicing — related questions