Oracle 11G OCP 1Z0-052 144

（144）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 receive an error.

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

答案：（B、C）

解析：

D（X），错误脱机之后直接就记录，而不是到关闭实例的时候才记录.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1224813/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1224813/