QUESTION 196 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.
{"Image DocumentName": "QUESTION 196Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key.", "Image ImageDescription": "FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE. Which UPDATE statement is valid? UPDATE employees SET first_name = John SET last_name = Smith\u2018 WHERE employee_id = 180; UPDATE employees SET first_name = John , SET last_name = Smith\u2018 WHERE employee_id = 180; UPDATE employee SET first_name = John AND last_name = Smith\u2018 WHERE employee_id = 180; UPDATE employee SET first_name = John , last_name = Smith WHERE employee_id = 180;", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}