Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
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’, last_name =’Smith’
WHERE employee_id = 180;
C.
UPDATE employees
SET first_name = ‘John’
SET last_name =’Smith’
WHERE employee_id = 180;
D.
UPDATE employees
SET first_name = ‘John’
AND last_name =’Smith’
WHERE employee_id = 180;