Exam 1z0-071 Topic 5 Question 28 Discussion

Actual exam question for Oracle's 1z0-071 exam
Question #: 28
Topic #: 5

Examine the description of the EMPLOYEES table:

Which statement increases each employee's SALARY by the minimum SALARY for their DEPARTM ENT_ID?

A. UPDATE employees e1
SET salary =(SELECT e2. salary + MIN(e2.salary)
FROM employees e2
WHERE e1.department_ id = e2. department_id GROUP BY e2. department_id) ; B. UPDATE employees e1
SET salary = salary+(SELECT MIN (salary)
FROM employees e2) ; C. UPDATE employees e1
SET salary = salary +
(SELECT MIN(e1. salary)
FROM employees e2
WHERE e1.department_id = e2 .department_id); D. UPDATE employees e1
SET salary=
(SELECT e1.salary + MIN(e2.salary)
FROM employees e2
WHERE e1. department_ id = e2.department_id);

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business