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.
Altering a tablespace to Offline:
You can take an online tablespace offline so that this portion of the database is temporarily unavailable for general use. The rest of the database is open and available for users to access data. When you take it offline, you can use the following options:
– Normal: A tablespace can be taken offline normally if no error conditions exist for any of the data files of the tablespace. Oracle Database ensures that all data is written to disk by taking a checkpoint for all data files of the tablespace as it takes them offline.
– Temporary: A tablespace can be taken offline temporarily even if there are error conditions for one or more files of the tablespace. Oracle Database takes the data files (which are not already offline) offline, performing checkpointing on them as it does so. If no files are offline, but you use the Temporary clause, media recovery is not required to bring the tablespace back online. However, if one or more files of the tablespace are offline because of write errors, and you take the tablespace offline temporarily, the tablespace requires recovery before you can bring it back online.
– Immediate: A tablespace can be taken offline immediately without Oracle Database taking a checkpoint on any of the data files. When you specify 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.
– For Recover: The FOR RECOVER setting has been deprecated. The syntax is supported for backward compatibility.
ANSWER E.
you CANNOT take offline the tablespaces: SYSTEM , temporary, undo