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.
If the above operation were successful, instance recovery would be required to
bring the tablespace online.
B.
The operation would fail if tbs_1 were a read-only tablespace.
C.
The operation would fail if tbs_1 were a read/write tablespace.
D.
The operation would fail if tbs_1 were the default tablespace for the database.
E.
If the above operation were successful, media recovery would be required to bring
the tablespace online.
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces005.htm#ADMIN11376
Find IMMEDIATE clause
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.
E