- 搜標(biāo)題
- 搜題干
- 搜選項(xiàng)
單項(xiàng)選擇題
管理Oracle數(shù)據(jù)庫。Jack負(fù)責(zé)管理“銷售”部門。他和他的雇員經(jīng)常需要查詢數(shù)據(jù)庫以確定客戶及其訂單。他要求您創(chuàng)建一個視圖，為他和他的同事簡化此過程。此視圖不接受INSERT、UPDATE或DELETE操作。應(yīng)執(zhí)行以下哪條語句（）
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
你可能感興趣的試題
