试题详情
- 单项选择题 Examine the data in the EMPLOYEES table.
On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column. Evaluate this DELETE statement: 
Why does the DELETE statement fail when you execute it?（） A、There is no row with dept_id 90 in the EMPLOYEES table.
B、You cannot delete the JOB_ID column because it is a NOT NULL column.
C、You cannot specify column names in the DELETE clause of the DELETE statement.
D、You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.
关注下方微信公众号，在线模考后查看
热门试题
- Which two statements
- What is true of usin
- Which two are charac
- You need to perform
- Evaluate the SQL st
- The EMPLOYEES table
- The CUSTOMERS table
- Which SQL statement
- Which SELECT stateme
- Examine the structu
- In which scenario wo
- Examine the data in
- Which three are DATE
- Examine the descrip
- In which two cases w
- In which scenario wo
- Evaluate the SQL sta
- For which two action
- You are granted the
- Examinethedescriptio