单选题
Examine the data in the EMPLOYEES table. EMPLOYEES EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD.ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EK_DIR 8000 120 Revi 20 110 SA_DIR 6500 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?（）
发布日期：2020-04-10
There is no row with dept_id 90 in the EMPLOYEES table.
You cannot delete the JOB_ID column because it is a NOT NULL column.
You cannot specify column names in the DELETE clause of the DELETE statement.
You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
CMS专题
CMS专题
其他考试
Passengers can begin to earn Miles _____.
患者男，50岁，因“上腹隐痛不适，食欲减退3个月”来诊。体重50kg。实验室检查：Hb80g/L，血浆清蛋白30g/L，血清钠130mmol/L，钾4.5mmol/L，动脉血pH7.35。胃镜：胃体癌。按血清钠浓度和公式计算需补充的钠盐量（mmol/L）为（）
乐乐不小心或无意中碰疼了别的小朋友的时候，能主动道歉，说明乐乐是一个有（）的幼儿。
纳税人提出调整定额必须是经营收入变化超过（）。
出租或使用的建筑起重机械应有特种设备（）以及检测合格证明、定期检测记录等资料。
关于持续性房颤，下列叙述不正确的是（）。
简述资本原始积累的实质。
排水沟的施工应符合的规定有（）。
乔戈里峰是世界第二高峰，也是国际登山界公认的八千米以上攀登难度最大的山峰，它位于我国（）境内。
Fireworks MX 2004提供了（）种热点工具。
暂无相关推荐~
Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary k...
Examine the data in the EMPLOYEES table. On the EMPLOYEES table, EMPLOYEE_ID is ...
Examine the data in the EMPLOYEES table. EMPLOYEES EMP_NAME DEPT_ID MGR_ID JOB_I...
Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary k...
Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary k...
Examine the data in the EMPLOYEES and DEPARTMENTS tables: Also examine the SQL s...
Examine the data in the EMPLOYEES and DEPARTMENTS tables. EMPLOYEES LAST_NAME DE...
Examine the data in the EMPLOYEES and EMP_HIST tables: EMPLOYEES NAME DEPT_ID MG...
Exhibit Examine the data in the EMPLOYEES and DEPARTMENTS tables. You want to re...
Examine the data in the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMP_NAME DEP...