试题详情
- 单项选择题 Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement： SQL>ALTER TABLSPACE temp OFFLINE NORMAL； What is the result of this statement？（）
A、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.
B、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.
C、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.
D、 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.
- D
关注下方微信公众号，在线模考后查看
热门试题
- While tuning a SQL s
- Which of
- In your
- Oracle用于保存二进制大对象的数据类
- Which two̳
- Which three tasks ca
- 关于SQL*PLUS的叙述正确的是（）
- What is the result o
- Given：
- Which two̳
- You discover&en
- You are administerin
- The RECYCLEBIN para
- Which statements are
- Your database&
- DRAGDROPClicktheTask
- You createQ
- 对于ORACLE PL/SQL标识符（
- Review the definiti
- 逻辑备份时，备份文件的扩展名一般是（）扩