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;
查看答案
该试题由用户199****39提供
查看答案人数:24940
如遇到问题请
联系客服
正确答案
该试题由用户199****39提供
查看答案人数:24941
如遇到问题请联系客服