DBI202Xuất hiện trong 2 đề thi
Which is the SQL statement that creates an updatable view? In this question, all the tables in the SQL statements are updatable.
Các lựa chọn
ACREATE VIEW Ordered_Product(Product_No) AS SELECT DISTINCT Product_No FROM Order
BCREATE 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
CCREATE VIEW Product_Order(Product_No, Order_Quantity) AS SELECT Product_No, SUM(Order_Quantity) FROM Order GROUP BY Product_No
DCREATE VIEW Expensive_Product(Product_No, Product_Name) AS SELECT Product_No, Product_Name FROM Product WHERE Product_Unit_Price>1000