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.
答案:BC
解析:参考:http://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces005.htm#ADMIN11376
offline的时候可以有下面几种情况
NORMAL-会执行checkpoint
TEMPORARY-在数据文件损坏的情况下执行offline
IMMEDIATE-在归档下才可以offline,online的时候需要recover,不执行checkpoint
FOR RECOVER-在归档下才可以offline,主要是时间点恢复使用
A:错误
B:正确,触发checkpoint有以下几种情况
1.日志切换的时候(ALTER SYSTEM SWITCH LOGFILE)
2.发出checkpoint命令(ALTER SYSTEM checkpoint)
3.ALTER TABLESPACE/DATAFILE READ ONLY
4.SHUTDOWN
5.ALTER TABLESPACE TS_NAME BEGIN BACKUP/END BACKUP
C:正确
D:正确,执行offline的时候就记录了
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.
答案:BC
解析:参考:http://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces005.htm#ADMIN11376
offline的时候可以有下面几种情况
NORMAL-会执行checkpoint
TEMPORARY-在数据文件损坏的情况下执行offline
IMMEDIATE-在归档下才可以offline,online的时候需要recover,不执行checkpoint
FOR RECOVER-在归档下才可以offline,主要是时间点恢复使用
A:错误
B:正确,触发checkpoint有以下几种情况
1.日志切换的时候(ALTER SYSTEM SWITCH LOGFILE)
2.发出checkpoint命令(ALTER SYSTEM checkpoint)
3.ALTER TABLESPACE/DATAFILE READ ONLY
4.SHUTDOWN
5.ALTER TABLESPACE TS_NAME BEGIN BACKUP/END BACKUP
C:正确
D:正确,执行offline的时候就记录了