程序员开发人员试题VIP免费

第1页共13页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第1页共13页1、哪一个SQL有错误？A.SELECT*FROMemp_dept_vu;B.SELECTdepartment_id,SUM(salary)FROMemp_dept_vuGROUPBYdepartment_id;C.SELECTdepartment_id,job_id,AVG(salary)FROMemp_dept_vuGROUPBYdepartment_id,job_id;D.SELECTjob_id,SUM(salary)FROMemp_dept_vuWHEREdepartment_idIN(10,20)GROUPBYjob_idHAVINGSUM(salary)>20000;E.没有一个错误，都是对的.2、两张表结构如下：EMPLOYEES（EMPLOYEE_IDNUMBERPrimaryKeyFIRST_NAMEVARCHAR2(25)LAST_NAMEVARCHAR2(25)HIRE_DATEDATE）NEW_EMPLOYEES（EMPLOYEE_IDNUMBERPrimaryKeyNAMEVARCHAR2(60)）哪一个删除语句是正确的。A.DELETEFROMemployeesWHEREemployee_id=(SELECTemployee_idFROMemployees);B.DELETE*FROMemployeesWHEREemployee_id=(SELECTemployee_idFROMnew_employees);C.DELETEFROMemployeesWHEREemployee_idIN(SELECTemployee_idFROMnew_employeesWHEREname='Carrey');D.DELETE*FROMemployeesWHEREemployee_idIN(SELECTemployee_idFROMnew_employeesWHERElast_name='Carrey');第2页共13页第1页共13页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第2页共13页3、显示每个部门，最高SALARY，最小SALARY，且最小SALARY小于5000，最大SALARY大于15000。A.SELECTdept_id,MIN(salary),MAX(salary)FROMemployeesWHEREMIN(salary)<5000ANDMAX(salary)>15000;B.SELECTdept_id,MIN(salary),MAX(salary)FROMemployeesWHEREMIN(salary)<5000ANDMAX(salary)>15000GROUPBYdept_id;C.SELECTdept_id,MIN(salary),MAX(salary)FROMemployeesHAVINGMIN(salary)<5000ANDMAX(salary)>15000;D.SELECTdept_id,MIN(salary),MAX(salary)FROMemployeesGROUPBYdept_idHAVINGMIN(salary)<5000ANDMAX(salary)>15000;E.SELECTdept_id,MIN(salary),MAX(salary)FROMemployeesGROUPBYdept_id,salaryHAVINGMIN(salary)<5000ANDMAX(salary)>15000;4、执行SQL:SELECT*FROMordersWHEREcust_id=(SELECTcust_idFROMcustomersWHEREcust_name='Smith');第3页共13页第2页共13页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第3页共13页5、students表结构如下：STD_IDNUMBER(4)COURSE_IDVARCHAR2(10)START_DATEDATE第4页共13页第3页共13页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第4页共13页END_DATEDATE哪两个在列START_DATE上的运算是正确的？A.SUM(start_date)B.AVG(start_date)C.COUNT(start_date)D.AVG(start_date,end_date)E.MIN(start_date)F.MAXIMUM(start_date)6、EMPLOYEES表结构如下：EMP_IDNUMBER(4)NOTNULLLAST_NAMEVARCHAR2(30)NOTNULLFIRST_NAMEVARCHAR2(30)DEPT_IDNUMBER(2)哪个SQL语句实现last_name为‘Smith’不同DEPT_ID的总数？A.SELECTCOUNT(*)FROMemployeesWHERElast_name='Smith';B.SELECTCOUNT(dept_id)FROMemployeesWHERElast_name='Smith';C.SELECTDISTINCT(COUNT(dept_id))FROMemployeesWHERElast_name='Smith';D.SELECTCOUNT(DISTINCTdept_id)FROMemployeesWHERElast_name='Smith';E.SELECTUNIQUE(dept_id)FROMemployeesWHERElast_name='Smith';7、查询所有employees表中的数据，无论在departments表中是否department_id的记录。哪个查询是正确的？第5页共13页第4页共13页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第5页共13页A.SELECTlast_name,department_nameFROMemployeesNATURALJOINdepartments;B.SELECTlast_name,department_nameFROMemployeesJOINdepartments;C.SELECTlast_name,department_nameFROMemployeeseJOINdepartmentsdON(e.department_id=d.department_id);D.SELECTlast_name,department_nameFROMemployeeseRIGHTOUTERJOINdepartmentsdON(e.department_id=d.department_id);E.SELECTlast_name,department_nameFROMemployeesFULLJOINdepartmentsON(e.department_id=d.department_id);F.SELECTlast_name,department_nameFROMemployeeseLEFTOUTERJOINdepart...