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： ORA01157： cannot identify/lock data file 201 see DBWR trace file ORA01110： data file 201： ’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason？（）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.

单项选择题

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：
ORA01157： cannot identify/lock data file 201 see DBWR trace file
ORA01110： data file 201： ’/u01/app/oracle/oradata/orcl/temp01.dbf’
What is a possible reason？（）

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.

相关考题

多项选择题 Lastnight，amediafailurecausedthelossofatemporaryfilethatbelongstoyourdatabase.Whichtwothingsmayhappenthismorningwhenyoutrytoopenyourdatabase？（）

单项选择题 Whilesettingupthethresholdsfortablespacespaceusagemetricsforoneofyourtablespaces，youdefinethecriticalthresholdas60%andwarningthresholdas75%.Whatwouldbetheresultofthissetting？（）

单项选择题 Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace space usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do？（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064

1z0-043