2025年程序员开发人员试题VIP专享

1、哪一种 SQL 有错误？A. SELECT * FROM emp_dept_vu;B. SELECT department_id, SUM(salary) FROM emp_dept_vuGROUP BY department_id;C. SELECT department_id, job_id, AVG(salary)FROM emp_dept_vuGROUP BY department_id, job_id;D. SELECT job_id, SUM(salary)FROM emp_dept_vuWHERE department_id IN (10,20)GROUP BY job_idHAVING SUM(salary) > 0;E. 没有一种错误，都是对的.2、两张表构造如下：EMPLOYEES（EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATE）NEW_EMPLOYEES（EMPLOYEE_ID NUMBER Primary KeyNAME VARCHAR2(60)）哪一种删除语句是对的的。A. DELETE FROM employeesWHERE employee_id = (SELECT employee_idFROM employees);B. DELETE * FROM employeesWHERE employee_id = (SELECT employee_idFROM new_employees);C. DELETE FROM employeesWHERE employee_id IN (SELECT employee_idFROM new_employeesWHERE name ='Carrey');D. DELETE * FROM employeesWHERE employee_id IN (SELECT employee_idFROM new_employeesWHERE last_name ='Carrey');3、显示每个部门，最高 SALARY，最小 SALARY，且最小 SALARY 不不小于 5000，最大 SALARY 不小于 15000。A. SELECT dept_id, MIN(salary), MAX(salary)FROM employeesWHERE MIN(salary) < 5000 AND MAX(salary) > 15000;B. SELECT dept_id, MIN(salary), MAX(salary)FROM employeesWHERE MIN(salary) < 5000 AND MAX(salary) > 15000GROUP BY dept_id;C. SELECT dept_id, MIN(salary), MAX(salary)FROM employeesHAVING MIN(salary) < 5000 AND MAX(salary) > 15000;D. SELECT dept_id, MIN(salary), MAX(salary)FROM employeesGROUP BY dept_idHAVING MIN(salary) < 5000 AND MAX(salary) > 15000;E. SELECT dept_id, MIN(salary), MAX(salary)FROM employeesGROUP BY dept_id, salaryHAVING MIN(salary) < 5000 AND MAX(salary) > 15000;4、执行 SQL:SELECT * FROM ordersWHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith');5、students 表构造如下：STD_ID NUMBER(4)COURSE_ID VARCHAR2(10)START_DATE DATEEND_DAT...