Oracle
1Z0-043 · Question #38
1Z0-043 Question #38: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-043 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
Question
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-01157: cannot identify/lock data file 201 . see DBWR trace file ORA-01110: data file 201: ./u01/app/oracle/oradata/orcl/temp01.dbf. What is a possible reason?
Options
- AThe tempfile belonging to the default temporary tablespace is missing.
- BThe database is opened in restricted mode, so queries are not allowed
- CThe default temporary tablespace required to execute the query is offline.
- DThe default temporary tablespace required to execute the query is dropped.
- EThe default temporary tablespace required to execute the query is read-only.
Unlock 1Z0-043 to see the answer
You've previewed enough free 1Z0-043 questions. Unlock 1Z0-043 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.