一、原题
二、题目翻译
三、题目解析
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
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
二、题目翻译
查看PRODUCTS, SALES, and SALE_SUMMARY表的结构:
SALE_VW是使用下面命令建立的一个视图:
执行下面的命令给SALE_SUMMARY添加一新行:
执行上面命令的结果是什么?
A.执行成功。
B.报错,因为复杂视图不能用于向SALE_SUMMARY表里添加数据。
C.报错,因为子查询中的列名与SALE_SUMMARY表中的列名不匹配。
D.报错,因为被插入的列的数量与SALE_SUMMARY表中列的数量不匹配。
SALE_VW是使用下面命令建立的一个视图:
执行下面的命令给SALE_SUMMARY添加一新行:
执行上面命令的结果是什么?
A.执行成功。
B.报错,因为复杂视图不能用于向SALE_SUMMARY表里添加数据。
C.报错,因为子查询中的列名与SALE_SUMMARY表中的列名不匹配。
D.报错,因为被插入的列的数量与SALE_SUMMARY表中列的数量不匹配。
三、题目解析
通过实验使用视图也可以与表进行连接操作,此题是由于列的数量不匹配造成的,
sale_summary后面没有写列名,就表示要插入所有的列(总共4列),但这里给的值只有3个值,所以会报值不够的错误
ORA-00947: not enough values
sale_summary后面没有写列名,就表示要插入所有的列(总共4列),但这里给的值只有3个值,所以会报值不够的错误
ORA-00947: not enough values