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 SALES tablespace is recorded in the control file when the database instance is closed.

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

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

D.
The sessions that subsequently try to access the objects in the SALES tablespace receive an error.



Leave a Reply 1

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


seenagape

seenagape

Correct answer is CD