OCP-1Z0-051 第159题 insert语句中使用子查询

一、原题

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

二、题目翻译

查看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关键字。