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. REATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
B. REATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C. REATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D. REATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
E. REATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;
查看答案
该试题由用户808****87提供
查看答案人数:48894
如遇到问题请
联系客服
正确答案
该试题由用户808****87提供
查看答案人数:48895
如遇到问题请联系客服