047-203

203. View the Exhibit button and examine the structures of ORDERS and

ORDER_ITEMS tables.In the ORDERS table, ORDER_ID is the PRIMARY KEY and in

the ORDER_ITEMS table, ORDER_ID and LINE_ITEM_ID form. the composite primary

key.Which view can have all the DML operations performed on it?

A. CREATE VIEW V1 AS SELECT order_id, product_id

FROM order_items;

B. CREATE VIEW V4(or_no, or_date, cust_id) AS SELECT order_id, order_date,

customer_id FROM orders WHERE order_date < '30mar2007' WITH CHECK OPTION;

C. CREATE VIEW V3 AS SELECT o.order_id, o.customer_id, i.product_id

FROM orders o, order_items I WHERE o.order_id=i.order_id;

D. CREATE VIEW V2 AS SELECT order_id, line_item_id, unit_price*quantity

total FROM order_items;

Answer: B

Performed:执行

不明白

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-718981/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11312660/viewspace-718981/