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 V1AS 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 ordersWHERE order_date < 30-mar-2007′ WITH CHECK OPTION;
C. CREATE VIEW V3AS 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 V2AS SELECT order_id, line_item_id, unit_price*quantity total FROM order items;
|
Download Printable PDF. VALID exam to help you PASS. |
 |