Which UPDATE statement is valid?

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?

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;



Leave a Reply 0

Your email address will not be published. Required fields are marked *