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.
B,C A incorrect
If you must take a tablespace offline, use the NORMAL clause (the default) if possible. This setting guarantees that the tablespace will not require recovery to come back online, even if after incomplete recovery you reset the redo log sequence using an ALTER DATABASE OPEN RESETLOGS statement.
A tablespace can be taken offline normally if no error conditions exist for any of the datafiles of the tablespace. No datafile in the tablespace can be currently offline as the result of a write error. When you specify OFFLINE NORMAL, the database takes a checkpoint for all datafiles of the tablespace as it takes them offline. NORMAL is the default.