Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the
immediate option. Which statement is correct in this scenario?
A.
The operation would fail if tbs_1 were a read-only tablespace.
B.
The operation would fail if tbs_1 were a read/write tablespace.
C.
The operation would fail if tbs_1 were the default tablespace for the database.
D.
If the above operation were successful, media recovery would be required to bring the tablespace
online.
E.
If the above operation were successful, instance recovery would be required to bring the
tablespace online.
A tablespace can be taken offline immediately, without the database taking a checkpoint on any of the datafiles. When you specify OFFLINE IMMEDIATE, media recovery for the tablespace is required before the tablespace can be brought online. You cannot take a tablespace offline immediately if the database is running in NOARCHIVELOG mode.
Taking Tablespaces Offline
You may want to take a tablespace offline for any of the following reasons:
To make a portion of the database unavailable while allowing normal access to the remainder of the database
To perform an offline tablespace backup (even though a tablespace can be backed up while online and in use)
To make an application and its group of tables temporarily unavailable while updating or maintaining the application
To rename or relocate tablespace datafiles
When a tablespace is taken offline, the database takes all the associated files offline.
You cannot take the following tablespaces offline:
SYSTEM
The undo tablespace
Temporary tablespaces
OFFLINE IMMEDIATE – Media recover
When you specify OFFLINE IMMEDIATE, media recovery for the tablespace is required
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces005.htm