【中文】OCP 071考试题库(cuug内部资料)第28题
OCP 071中文考试题库(cuug内部资料)第28题本套题库是OCP考试中的071(中文版)试题，由CUUG整理，如有报考OCP认证意向，可以联系cuug咨询老师。28、请选择最佳答案。查看EMPLOYEES表的说明:Name Null? Type-------- ------- -------EMPLOYEE_ID NOT NULL NUMBER(38)SALARY NOT NULL NUMBER(38)DEPARTMENT_ID NOT NULL NUMBER(38)哪一条语句会将每个员工的SALARY增加其DEPARTMENT_ID的最低SALARY?A) UPDATE employees e1SET salary =(SELECT e2.salary + MIN (e2.salary)FROM employees e2WHERE e1.department_id = e2.department_idGROUP BY e2.department_id) ;B) UPDATE employees e1SET salary =(SELECT e1.salary + MIN (e2.salary)FROM employees e2WHERE e1. department_id = e2.department_id) ;C) UPDATE employees e1SET salary = salary +(SELECT MIN(e1.salary)FROM employees e2WHERE e1.department_id = e2.department_id) ;D) UPDATE employees e1SET salary = salary +(SELECT MIN(salary)FROM employees e2) ;
页:
[1]