The record group in the EMP form is populated using a SELECT

以下说法错误的是( )

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;

Examine the structure of the EMP_DEPT_VU view:Column Name Type RemarksEMPLOYEE_ID NUMBER From the EMPLOYEES tableEMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES tableSALARY NUMBER From the EMPLOYEES tableDEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）

A. SELECT * FROM emp_dept_vu;

B. SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;

C. SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;

D. SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000

E. None of the statements produce an error; all are valid.

以下语句错误的是( )

A.select sal+1 from emp;

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

C.不能使用运算符号

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

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;

A.v_record emp%type;

B.v_record emp%recordtype;

C.v_record emp%record_type;

D.v_record emp%rowtype;

E.v_record emp%row_type;

统计每个部门中人数( )

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;

A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.

B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.

C. The SQL* Loader operation fails because no record terminators are specified.

D. Field names should be the first line in the both the SQL* Loader data files.

E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

以下语句不正确的是( )

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;

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;

A.SELECT TOP 5 * FROM EMP

B.SELECT DISTINCT 5 * FROM EMP

C.SELECT * FROM EMP WHERE ROWNUM<6

D.SELECT * FROM EMP WHERE ROWNUM=5