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.)

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 new status of the SALEStablespace is recorded in the control file when the
database instance is closed.

B.
Thetablespace would require recovery to go back online.

C.
A checkpoint is taken on all data files that are associated with the
SALEStablespace.

D.
The sessions that subsequently try to access the objects in the SALEStablespace
receivean error.



Leave a Reply 1

Your email address will not be published. Required fields are marked *