题目内容

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;
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

查看答案
更多问题

电缆改建施工时,应采取哪些安全措施?

以下各项中,()属于投资收益。

A. 长期持有的股票或债券在持有期间所收到的现金股利或债券利息
B. 售出证券或收回其他投资时取得的收入与其账面价值相比的差额
C. 权益法下分享被投资方接受捐赠增加的净资产
D. 长期股权投资差额的摊销

甲因盗窃被公安机关决定治安拘留15日,同时查明其还有抢夺行为,对其抢夺决定治安拘留10日,根据《治安管理处罚法》的规定,甲应执行治安拘留()。

A. 10日
B. 14日
C. 20日
D. 25日

被誉为“宪政之母”的国家是()。

A. 美国
B. 英国
C. 法国
D. 中国

答案查题题库