Which statements describe the effect of the command?

You execute the following command to change the status of the SALES tablespace:
SQL> ALTER TABLESPACE sales OFFLINE;
Which statements describe the effect of the command? (Choose all that apply.)

A.
The tablespace would require recovery to go back online.

B.
A checkpoint is taken on all data files that are associated with the SALES tablespace.

C.
The sessions that subsequently try to access the objects in the SALES tablespace receivean
error.

D.
The new status of the SALES tablespace is recorded in the control file when the database
instance is closed.

Explanation:
Altering a Tablespace (continued)
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 yon 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.