试题详情
- 单项选择题 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；
- A
关注下方微信公众号，在线模考后查看
热门试题
- You have
- For which two action
- Examine the structu
- Given classes&e
- You work
- Examinethestructureo
- Exhibit， One&en
- In which
- You are using Recov
- 撤销用户指定权限的命令是（）。
- Given: Whichtwo,ins
- Given： Which c
- You examine the out
- What is
- While performi
- When performin
- In your d
- Which substitution v
- You are u
- Which statement abou