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
答案继续：
参考：http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_10008.htm#SQLRF55448
Explanation:
