搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

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

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.

查看正确答案
更多“ You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables:<br /> EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME.<br /> The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table.<br /> You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables.<br /> How can you accomplish this task?（）”相关的问题
第1题
[单选题] You are granted the CREATE VIEW privilege. What does this allow you to do?（）

A、Create a table view.  B、Create a view in any schema.  C、Create a view in your schema.  D、Create a sequence view in any schema.  E、Create a view that is accessible by everyone.  F、Create a view only of it is based on tables that you created.  

点击查看答案
第2题
[单选题] You are granted the CREATE VIEW privilege. What does this allow you to do? （）

A、Create a table view.  B、Create a view in any schema.  C、Create a view in your schema.  D、Create a sequence view in any schema.  E、Create a view that is accessible by everyone.  F、Create a view only of it is based on tables that you created.  

点击查看答案
第3题
[] You are granted the CREATE VIEW privilege. What does this allow you to do?（）

A、A. Create a table view.  B、B. Create a view in any schema.  C、C. Create a view in your schema.  D、D. Create a sequence view in any schema.  E、E. Create a view that is accessible by everyone.  F、F. Create a view only of it is based on tables that you created.  

点击查看答案
第4题
[单选题] What does the FORCE option for creating a view do?（）

A、creates a view with constraints  B、creates a view even if the underlying parent table has constraints  C、creates a view in another schema even if you don't have privileges  D、creates a view regardless of whether or not the base tables exist  

点击查看答案
第5题
[单选题] What does the FORCE option for creating a view do?（）

A、creates a view with constraints  B、creates a view even if the underlying parent table has constraints  C、creates a view in another schema even if you don't have privileges  D、creates a view regardless of whether or not the base tables exist  

点击查看答案
第6题
[单选题] What does the FORCE option for creating a view do?（）

A、creates a view with constraints  B、creates a view even if the underlying parent table has constraints  C、creates a view in another schema even if you don't have privileges  D、creates a view regardless of whether or not the base tables exist  

点击查看答案
第7题
[单选题] What does the FORCE option for creating a view do? （）

A、creates a view with constraints  B、creates a view even if the underlying parent table has constraints  C、creates a view in another schema even if you don't have privileges  D、creates a view regardless of whether or not the base tables exist  

点击查看答案
第8题
[] You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?（） You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?（）

A、A. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);  B、B. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;  C、C. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;  D、D. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);  E、E. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;  

点击查看答案
第9题
[单选题] You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? （）

A、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);  B、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;  C、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;  D、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);  E、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;  

点击查看答案
第10题
[单选题] You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.Which SQL statement would you use to create the view EMP_VU?（）

A、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);  B、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;  C、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;  D、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);  E、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服