题库
  • 题库
  • 考试

移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

首页 / 其他类/ CMS专题/ / 当前试题

单选题

分享题目

Examine the data in the EMPLOYEES and DEPARTMENTS tables: Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: What happens when you execute the DELETE statement?（）

发布日期：2021-01-28

Examine the data in the EMPLOYEES and DEPARTMENTS ...
A

Only the row with department ID 40 is deleted in the DEPARTMENTS table.

B

The statement fails because there are child records in the EMPLOYEES table with department ID 40.

C

The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.

D

The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.

E

The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.

F

The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.

标签： examine data employees departments tables

查看答案

题王网让考试变得更简单

扫码关注题王，更多免费功能准备上线！

此试题出现在

CMS专题

CMS专题

去刷题

其他考试

环保气象安全技能考试 微生物检验技术中级职称 儿科主治医师 卫生检验技术（技师） 网络设备调试员 环保知识生态建设知识竞赛 思科认证考试 神经电生理脑电图技术(师) 中级审计师 大学生村官考试
热门试题热门资讯 相关试题

import java.io.PrintWriter；  class DoFormat {  public static void main（String [] args） { int x = 42； int y = 12345；  float z = 7； System.out.format（"-%4d- "， x）；  System.out.format（"-%4d- "， y）；  System.out.format（"-%4.1d- "， z）； } }  结果为：（） 

里程碑计划是以项目中某些重要事件的开始或完成时间点为基准的计划，主要用于编制（）

库存系统通常有四部分组成，他们是（）、补充、约束和（）。

两种药物治疗糖尿病的疗效见下表，请回答下列问题 不同的处理组称为统计表的

《国家重大建设项目文件归档要求与档案整理规范》规定，涉及结构形式、工艺、平面布置、项目等重大改变及图面变更面积超过了（）的，应重新绘制竣工图。

微处理器的重要性能指标之一是主频，主频越高它的运算速度越快。

讲课浅入深出，这种老师的教学，就只能是（）的了。

伊斯兰教的两大教派是逊尼派和什叶派。

火场勘验时，要检测铁磁性材料或构件的剩磁强度，应使用（）。

在潮湿地区采用Ⅲ型涂装体系进行大面积钢梁涂装作业，漆膜总厚度不应小于（）。

暂无相关推荐~

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...