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.
D is correct: immediate offline: A tablespace can be taken offline immediately, without Oracle’s taking a checkpoint on any of the datafiles. With immediate offline priority, 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.
https://riddle.ru/mirrors/oracledocs/server/sad73/ch803.html