Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which UPDATE statement is valid?()
A. UPDATEnew_employeesSETname=(SELECTlast_nameFirst_nameFROMemployeesWHEREemployee_id=180)WHEREemployee_id=180;
B. UPDATEnew_employeesSETname=(SELECTlast_nameFirst_nameFROMemployees)WHEREemployee_id=180;
C. UPDATEnew_employeesSETname=(SELECTlast_nameFirst_nameFROMemployeesWHEREemployee_id=180) WHEREemployee_id=(SELECTemployee_idFROMnew_employees);
D. UPDATEnew_employeesSETname=(SELECTlast_nameFirst_nameFROMemployeesWHEREemployee_id=(SELECTemployee_idFROMnew_employees) WHEREemployee_id=180;