Oracle Database 11g: Administration I — Question 8

Your database is configured in archivelog mode.
The USERS01 tablespace is currently online.
You are required to take the tablespace offline.
Which clause or clauses ensure that no media recovery is required when the tablespace is brought back online?

Answer options

• A. either the NORMAL or the IMMEDIATE clause
• B. only the IMMEDIATE clause
• C. either the NORMAL or the TEMPORARY clause
• D. only the TEMPORARY clause
• E. only the NORMAL clause

Correct answer: D

Explanation

The correct answer is D because using the TEMPORARY clause allows the tablespace to be taken offline without requiring media recovery. The other options either do not guarantee this condition or are not suitable for ensuring no recovery is needed.