问题:
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;
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?()
● 参考解析
本题暂无解析
相关内容
相关标签