Kizspy | Question: 35
(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
