第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;
第2题:
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.
第3题:
以下语句错误的是( )
A.select sal+1 from emp;
B.select sal*10,sal*deptno from emp;
C.不能使用运算符号
D.select sal*10,deptno*10 from emp;
第4题:
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?()
第5题:
A.select * from emp wher sal in (2000,3000);
B.select * from emp wher sal like (2000,3000);
C.select * from emp wher sal = (2000,3000);
D.select * from emp wher sal between 2000 and 3000;
第6题:
统计每个部门中人数( )
A.SELECT SUM(ID) FROM EMP GROUP BY DEPTNO;
B.SELECT SUM(ID) FROM EMP ORDER BY DEPTNO;
C.SELECT COUNT(ID) FROM EMP ORDER BY DEPTNO;
D.SELECT COUNT(ID) FROM EMP GROUP BY DEPTNO;
第7题:
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 abovesyntax 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;
第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;
第9题:
A.select job from emp;
B.select job,count(*) from emp;
C.select distinct job,count(*) from emp;
D.select job,count(*) from emp group by job;
E.select job,sum(empno) from emp group by job;
第10题:
下面的查询中哪一个会产生笛卡尔集()