Multiple choice technology programming languages

The database administrator is taking the cbgb tablespace offline, due to erroneous datafiles in the tablespace. Which offline tablespace option should be chosen?

  1. NORMAL

  2. TEMPORARY

  3. IMMEDIATE

  4. FOR RECOVER
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When a tablespace has erroneous or corrupted datafiles, the TEMPORARY offline option is appropriate because it brings the tablespace offline without performing a checkpoint on the datafiles. NORMAL requires a checkpoint and clean datafiles, IMMEDIATE is used for emergency situations when NORMAL fails, and FOR RECOVER is used when the tablespace needs media recovery before being brought online.

Keep practicing — related questions