单选题
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? （）
发布日期：2020-04-10
CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);
CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);
CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
CMS专题
CMS专题
其他考试
发达商品流通是第几次社会大分工的产物（）
按反切的一般原则用普通话拼读，为什么有的反切读不准？
不属于丙酮酸酵解终产物的是（）
具有凉血止血，散瘀消痈功效的药物是（）
在下列材料中，收缩量最大的材料是（）
Nessus服务器开启后的默认端口为（）。
何谓“四.七”关井程序？
氨苯蝶啶有以下作用但除外（）
下列矿山开采阶段安全事故防范措施，正确的是（ ）。
重度妊高征的治疗方法首先考虑解痉
暂无相关推荐~
You need to create a view EMP_VU. The view should allow the users tomanipulate t...
You need to create a view EMP_VU. The view should allow the users to manipulate ...
You need to create a view EMP_VU. The view should allow the users to manipulate ...
You need to create a view EMP_VU. The view should allow the users to manipulate ...
评估此CREATE VIEW 语句： CREATE VIEW pt_view AS (SELECT first_name, last_name, status,...
评估此CREATE VIEW语句： CREATE VIEW emp_view AS SELECT SUM(salary) FROM employees; 以下哪...
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...
You are granted the CREATE VIEW privilege. What does this allow you to do?（）
You are granted the CREATE VIEW privilege. What does this allow you to do? （）