试题详情
- 单项选择题 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；
关注下方微信公众号，在线模考后查看
热门试题
- Which two tasks can
- Examinethedescriptio
- What is true about j
- Examine the structu
- Mary has a view cal
- ExaminethedataintheE
- The EMPLOYEES table
- Examine this statem
- The PRODUCTS table
- Which two tasks can
- What is necessary fo
- Which are iSQL*Plus
- In which scenario wo
- The EMPLOYEES table
- Which four are corre
- What are two reasons
- What does the TRUNCA
- The STUDENT_GRADES
- ClicktheExhibitbutto
- You need to perform