试题详情
- 单项选择题 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 DELETE statement is valid? （）
A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'
D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'
关注下方微信公众号，在线模考后查看
热门试题
- Evaluate this SQL s
- You need to modify t
- Which two statements
- Management has aske
- Which describes the
- ClicktheExhibitbutto
- You added a PHONE_N
- Which iSQL*Plus feat
- Which three SELECT s
- In a SELECT statemen
- TheEMPLOYEEStablehas
- Examine these state
- Which three are true
- Examine the descrip
- Which two statements
- Examine the descrip
- TheSTUDENT_GRADEStab
- Examine the descrip
- You need to design
- Which two statements