niusouti.com
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 * F
题目
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;
相似考题
更多“You need to create a view EMP_VU. The view should allow the users to manipulate the record ”相关问题
-
第1题：
【填空题】以下代码，创建St_view视图以查询StInfo表中女生的所有信息。（注：请用大写字母答题） CREATE ______ St_view AS SELECT * FROM StInfo WHERE St_sex=‘女’
对 -
第2题：
10、所有的View都会放在左上角,并且后添加进去的View会覆盖之前放进去的View。具有这种特点的布局是帧布局（）
正确 -
第3题：
对于View类，一般包含哪些内部接口实现事件监听。（）
A．View.OnClickListener
B．View.OnKeyListener
C．View.OnLongClickListener
D．View.OnTouchListener
View.OnClickListener;View.OnKeyListener;View.OnLongClickListener;View.OnTouchListener -
第4题：
从菜单选择（）命令恢复原理图完整视图。
A．View→ Fit All Objects
B．View→Area
C．view →zoomIn
D．view →zoomOut
View→ Fit All Objects -
第5题：
【单选题】对于建立在数据库上的DDL触发器，常用的激活DDL触发器的事件不包括（）
A．Create_Table，Alter_Table，Drop_Table
B．Create_View，Alter_View，Drop_View
C．Create_Procedure，Alter_Procedure，Drop_Procedure
D．Rollback
Rollback -
第6题：
【填空题】创建、修改和删除视图命令分别是__________view、_________ view和_________ view
CREATE VIEW