Kizspy | Question: 44
(Choose 1 answer)
Which is the SQL statement that creates an updatable view? In this question, all the tables in the SQL
statements are updatable.
A. CREATE VIEW Ordered_Product(Product_No) AS SELECT DISTINCT Product No FROM Order
B. CREATE VIEW Order_List(Order_No, Product Name, Order Quantity) AS SELECT Order_No,
Product Name, Order Quantity FROM Order, Product WHERE Order.Product_No-Product.Product_No
C. CREATE VIEW Product Order(Product_No, Order Quantity) AS SELECT Product No,
SUM(Order Quantity) FROM Order GROUP BY Product_No
D. CREATE VIEW Expensive Product(Product_No, Product Name) AS SELECT Product No,
Product Name FROM Product WHERE Product Unit Price>1000
