单选题
A user executes a query on the EMP table， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal; SELECT ename FROM emp WHERE deptno=10 ORDER BY sal * ERROR at line 1： ORA/x7f01157： cannot identify/lock data file 201 /x7f see DBWR trace file ORA/x7f01110： data file 201： ’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason？（）
发布日期：2022-06-12
A
The tempfile belonging to the default temporary tablespace is missing.
B
The database is opened in restricted mode， so queries are not allowed.
C
The default temporary tablespace required to execute the query is offline.
D
The default temporary tablespace required to execute the query is dropped.
E
The default temporary tablespace required to execute the query is readonly.
标签： "暂无标签"
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在