一、原题
二、题目翻译
三、题目解析
View the Exhibit and examine the structure of the CUSTOMERS table.

NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the corresponding columns in the CUSTOMERS table.
Evaluate the following INSERT statement:
INSERT INTO new_customers
(cust_id, cust_name, cust_city)
VALUES
(SELECT cust_id, cust_first_name|| ' '||cust_last_name, cust_city
FROM customers
WHERE cust_id > 23004);
The INSERT statement fails when executed. What could be the reason?
A. The VALUES clause cannot be used in an INSERT with a subquery.
B. Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match.
C. The WHERE clause cannot be used in a subquery embedded in an INSERT statement.
D. The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table.
答案:A
NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the corresponding columns in the CUSTOMERS table.
Evaluate the following INSERT statement:
INSERT INTO new_customers
(cust_id, cust_name, cust_city)
VALUES
(SELECT cust_id, cust_first_name|| ' '||cust_last_name, cust_city
FROM customers
WHERE cust_id > 23004);
The INSERT statement fails when executed. What could be the reason?
A. The VALUES clause cannot be used in an INSERT with a subquery.
B. Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match.
C. The WHERE clause cannot be used in a subquery embedded in an INSERT statement.
D. The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table.
答案:A
二、题目翻译
查看CUSTOMERS表的结构
NEW_CUSTOMERS是一个新表,它的CUST_ID, CUST_NAME and CUST_CITY列的数据类型和大小与CUSTOMERS相同.
评估下面的INSERT语句
执行失败的原因是什么?
A.VALUES子句不能用于带有子查询的INSERT语句。
B.NEW_CUSTOMERS表中的列名与CUSTOMERS表不匹配。
C.嵌入在一个INSERT语句中的子查询不能使用WHERE子句。
D.NEW_CUSTOMERS表中列的全部数量与CUSTOMERS表中列的全部数量不匹配。
NEW_CUSTOMERS是一个新表,它的CUST_ID, CUST_NAME and CUST_CITY列的数据类型和大小与CUSTOMERS相同.
评估下面的INSERT语句
执行失败的原因是什么?
A.VALUES子句不能用于带有子查询的INSERT语句。
B.NEW_CUSTOMERS表中的列名与CUSTOMERS表不匹配。
C.嵌入在一个INSERT语句中的子查询不能使用WHERE子句。
D.NEW_CUSTOMERS表中列的全部数量与CUSTOMERS表中列的全部数量不匹配。
三、题目解析
values后面只能跟确定的值,如果需要使用子查询的结果集插入到表中,就不用带values关键字。