可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Click the Exhibit button and examine


Click the Exhibit button and 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: DELETE employee_id, salary, job_id FROM employees WHERE dept_id = 90; Why does the DELETE statement fail when you execute it?()

  • AThere is no row with dept_id 90 in the EMPLOYEES table.
  • BYou cannot delete the JOB_ID column because it is a NOT NULL column.
  • CYou cannot specify column names in the DELETE clause of the DELETE statement.
  • DYou cannot delete the EMPLOYEE_ID column because it is the primary key of the table.
参考答案
参考解析:
分类:1Z0-007题库