單項(xiàng)選擇題

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.

你可能感興趣的試題

多項(xiàng)選擇題

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

A.The database opens normally.
B.The database prompts for a database recovery.
C.The database writer writes to a trace file， indicating that the temporary file is not found.
D.The database gets mounted and throws an error indicating that the temporary file requires recovery.

單項(xiàng)選擇題

While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）

A.It would result in an error because the warning threshold cannot be more than the critical threshold.
B.The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
C.The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
D.Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.

你可能感興趣的試題

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）

While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）