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

最新推荐文章于 2016-03-23 11:57:15 发布

今年我18

最新推荐文章于 2016-03-23 11:57:15 发布

阅读量904

点赞数

CC 4.0 BY-SA版权

分类专栏： 1z0-051 文章标签： 1z0-051

本文链接：https://blog.youkuaiyun.com/dwj19830118/article/details/50902015

1z0-051 专栏收录该内容

175 篇文章

订阅专栏

探讨了使用SQL视图进行数据插入到表时遇到的问题，特别是当视图涉及聚合函数且目标表列数与视图返回列数不匹配时的情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.
答案：D
解析：insert 没有指定具体的列，那么默认就是全部列，这里的插入值和列数不符合