题库
  • 题库
  • 考试

移动端

  • 题王微信公众号

    题王微信公众号

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

首页 / 其他类/ 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 manager_id NUMBER);

B

MODIFY VIEW emp_dept_vu (ADD manager_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专题

去刷题

其他考试

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

在机器运转过程只有机油中加入润滑剂才能起到润滑的作用，减少磨损。

成人胸外电除颤的能量一般不要超过（）

建筑相关疾病和病态建筑综合症相同之处有化（）、（）和（）、随室内人员密度增加而增大。

早孕绒毛采样检查宜在孕（）进行。

辅助电机补偿电容的作用是（）。

取消发车进路时，应先通知（），再取消进路。

请根据所给材料结合你对高中《变色龙》原文的理解，为本次教学设计教学目标并指明重难点。

根据《高层民用建筑设计防火规范》，机械加压送风机的位置应根据（）等因素确定

具有防止褐变作用的维生素是（）

内审员在收集证据时，发现不符合项应随时让陪同人员确认

暂无相关推荐~

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