144.You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLE

最新推荐文章于 2022-02-18 14:11:33 发布

原创最新推荐文章于 2022-02-18 14:11:33 发布 · 691 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#1z0-052

1z0-052 专栏收录该内容

187 篇文章

订阅专栏

本文探讨了在Oracle数据库中将SALES表空间设置为离线状态的影响。具体包括触发检查点、拒绝后续访问尝试及状态记录等行为，并对常见误解进行了澄清。

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的时候就记录了