The DROP option is required if you take a datafile offline when your database is in ____ mode.
A) NOARCHIVELOG
B) NOLOGGING
C) TEMPORARY
D) IMMEDIATE

Question

Quizplus · Accepted Answer

When a database is in NOARCHIVELOG mode, taking a datafile offline requires the DROP option because in this mode, the database does not archive redo logs, making it impossible to recover changes that were not written to the datafile before it was taken offline.

The DROP Option Is Required If You Take a Datafile