ocpÌâ¿âÔõô±³£º11g-051-V9.02-µÚ162Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

162. View the Exhibit and examine the structure of the PRODUCTS, SALES, and SALE_SUMMARY

tables.

SALE_VW is a view created using the following command :

SQL>CREATE VIEW sale_vw AS

SELECT prod_id, SUM(quantity_sold) QTY_SOLD

FROM sales GROUP BY prod_id;

You issue the following command to add a row to the SALE_SUMMARY table :

SQL>INSERT INTO sale_summary

SELECT prod_id, prod_name, qty_sold FROM sale_vw JOIN products

USING (prod_id) WHERE prod_id = 16;

What is the outcome?

A. It executes successfully.

B. It gives an error because a complex view cannot be used to add data into the SALE_SUMMARY table.

C. It gives an error because the column names in the subquery and the SALE_SUMMARY table do not match.

D. It gives an error because the number of columns to be inserted does not match with the number of

columns in the SALE_SUMMARY table.

Answer: D

ÊÔÌâ½âÎö£º

ÓÉÓÚÁеÄÊýÁ¿²»Æ¥ÅäÔì³ÉµÄ£¬Èç¹ûÊýÁ¿Ò»Ö£¬»áÖ´Ðгɹ¦¡£

´øÓÐ×Ó²éѯµÄINSERTÓï¾ä£¬ÎðʹÓÃVALUES×Ӿ䣬²¢ÇÒʹINSERT×Ó¾äÖеÄÁÐÊýÓë×Ó²éѯÖеÄÁÐÊýÆ¥Åä¡£