1z0-043

单选题A user executes a query on the EMPtable， 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

题目
单选题
A user executes a query on the EMPtable， 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？（）
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 read-only.

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

以下说法错误的是( )

A.SELECT max(sal),deptno,job FROM EMP group by sal;

B.SELECT max(sal),deptno,job FROM EMP group by deptno;

C.SELECT max(sal),deptno,job FROM EMP;

D.SELECT max(sal),deptno,job FROM EMP group by job;


正确答案：C 

第2题：

The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）

A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;

B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;

C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;

D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;


参考答案：C

第3题：

以下语句错误的是( )

A.select sal+1 from emp;

B.select sal*10,sal*deptno from emp;

C.不能使用运算符号

D.select sal*10,deptno*10 from emp;


正确答案：C 

第4题：

Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"? （）

  • A、No change is required to achieve the desired results.
  • B、SELECT ename, sal, 12* (sal+100) FROM emp;
  • C、SELECT ename, sal, (12* sal)+100 FROM emp;
  • D、SELECT ename, sal +100,*12 FROM emp;

正确答案:B

第5题：

A user executes a query on the EMPtable， 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？（）

  • 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 read-only.

正确答案:A

第6题：

Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.


参考答案：B

第7题：

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？（）

  • 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 read­only.

正确答案:A

第8题：

以下语句不正确的是( )

A.select * from emp;

B.select ename,hiredate,sal from emp;

C.select * from emp order deptno;

D.select * from where deptno=1 and sal<300;


正确答案：C 

第9题：

下面的查询中哪一个会产生笛卡尔集（）

  • A、SELECT e.empno，e.ename， e.deptno， d.deptno，d.loc  FROM  emp e，dept  d WHERE e.deptno=d.deptno
  • B、SELECT e.empno， e.ename， e.deptno， d.deptno，d.loc FROM emp  e，dept  d
  • C、SELECT e.empno， e.ename， e.deptno， d.deptno，d.loc FROM emp e，dept d WHERE e.empno=101 and e.deptno=d.deptno
  • D、SELECT e.empno， e.ename， e.deptno， d.deptno，d.loc FROM emp e，dept  d WHEREe.deptno=d.deptno and d.deptno=60

正确答案:B

第10题：

查询出所有名字以’S’开始的员工（）

  • A、select * from emp where ename in 'S%';
  • B、select * from emp where ename='S%';
  • C、select * from emp where ename like 'S%';
  • D、select * from emp where ename like 'S_';

正确答案:C

更多相关问题
相关内容