试题详情
单项选择题管理Oracle数据库。Jack负责管理“销售”部门。他和他的雇员经常需要查询数据库以确定客户及其订单。他要求您创建一个视图,为他和他的同事简化此过程。此视图不接受INSERT、UPDATE或DELETE操作。应执行以下哪条语句()

A、CREATE VIEW sales_view AS(SELECT companyname,city,orderid,orderdate,total FROM customers,orders WHERE custid=custid}WITHREAD ONLY

B、CREATE VIEW sales_view(SELECT c.companyname,c.city,o.orderid,o.orderdate,o.tota lFROM customersc,orderso WHERE c.custid=o.custid}WITHREAD ONLY

C、CREATE VIEW sales_view AS(SELECT c.companyname,c.city,o.orderid,o.orderdate,o.total FROM customersc,orderso WHERE c.custid=o.custid}

D、CREATE VIEW sales_view AS(SELECT c.companyname,c.city,o.orderid,o.orderdate,o.total FROM customersc,orderso WHERE c.custid=o.custid)WITHREAD ONLY

  • D
  • 关注下方微信公众号,在线模考后查看

热门试题