ocp题库解析：1Z0-051-V9.02-第159题
ocp题库解析：1Z0-051-V9.02-第159题，完整题库请点击这里联系老师咨询了解
159. 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. values后面不能跟子查询，或者直接不要VALUES
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.
Answer: A
试题解析：
即insert into后面的如果有子句，则不用values
精华阅读