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.
Answer: BC
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12572003
Oracle DB 可以使表空间立即脱机,而 不需要为任何数据文件设置检查点。如果指定了“Immediate(立即)”,则必须先对表空间执行介质恢复,才能使表空间联机。如果数据库在NOARCHIVELOG模式下运行,则无法立即使表空间脱机。
FOR RECOVER设置已被废弃。支持此语法是为了向后兼容。
再分享一下我老师大神的人工智能教程吧。零基础!通俗易懂!风趣幽默!还带黄段子!希望你也加入到我们人工智能的队伍中来!https://blog.csdn.net/jiangjunshow