题库
  • 题库
  • 考试

移动端

  • 题王微信公众号

    题王微信公众号

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

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

单选题

分享题目

You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）

发布日期：2020-04-10

You created a view called EMP_DEPT_VU that contain...
A

ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);

B

MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);

C

ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;

D

MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;

E

CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;

F

You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.

标签： created view called emp_dept_vu columns

查看答案

题王网让考试变得更简单

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

此试题出现在

CMS专题

CMS专题

去刷题

其他考试

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

“安全”所表示的是一种状态，一种没有危险、不受威胁、不出事故的客观状态。（）

可申请行政复议的情形有哪些？

心绞痛与急性心肌梗死的鉴别诊断要点包括（）

（）的特殊性、经营管理的专业性以及涉及学科多、管理复杂等特点，决定了应对物业服务专业人员实行职业资格制度。

关于小肝癌的声像图表现，最不常见的是（）。

灌装间环境标准中要求霉菌（），沉将菌（）。

下列可根据总账科目期末余额直接填到资产负债表中的项目是（）。

下列对民主管理的说法是错误的（）。

1岁男婴，面色苍白3个月，近1周嗜睡，食欲缺乏；体检：虚胖，头发稀疏微黄，面色苍黄，巩膜轻度黄染，心尖收缩期Ⅱ级杂音，肝肋下0.5cm，脾未及。血常规检查结果RBC2.5×1012/L，Hb78g/L，MCV95fl，网织红细胞0.010，白细胞计数正常，有核分叶过多现象，血小板正常。最可能的诊断是（）

患者男性，40岁，右侧腮腺反复肿痛5年，进食后加重，无口干。1周前再次发作入院。检查见右侧腮腺大，导管口流出混浊液体，可及条索样导管，X线片显示导管呈腊肠样改变，此时诊断为（）。

暂无相关推荐~

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES,D...

You created a view called EMP_DEPT_VU that contains three columns from the EMPLO...

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, ...

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, ...

You created a view called EMP_DEPT_VU that contains three columns from the EMPLO...

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, ...

You created a view called EMP_DEPT_VU that contains three columns from the EMPLO...

A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, co...

A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, co...

A library called contosobuisness.dll has been created and u need to accept it in...