试题详情
- 单项选择题You need to create a view EMP_VU. The view should allow the users tomanipulate 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;
- C
关注下方微信公众号,在线模考后查看
热门试题
- Which statement crea
- In your multitenant
- What are
- 假设需要在数据库中创建角色test_ro
- The database
- You experience
- ClicktheExhibitbutto
- What is necessary fo
- Given: Which t
- For which two databa
- Which one̳
- Case 1:
- What component
- You are m
- 下列哪一项可以正确地引用该记录变量中的一
- To accomplish user-
- Your database&
- 假设需要导出某个表table1,只导出表
- You included&e
- Which statements ab