OCP-1Z0-051-2015-51题

QUESTION NO: 51

Examine the structure of the EMPLOYEES table:

Which UPDATE statement is valid?
A.
UPDATE employees

SET first_name = ‘John’

SET last_name = ‘Smith’
WHERE employee_id = 180;
B.
UPDATE employees
SET first_name = ‘John’,
SET last_name = ‘Smoth’
WHERE employee_id = 180;
C.
UPDATE employee
SET first_name = ‘John’
AND last_name = ‘Smith’
WHERE employee_id = 180;
D.
UPDATE employee
SET first_name = ‘John’, last_name = ‘Smith’
WHERE employee_id = 180;
Answer: D
Explanation: