OCP-1Z0-051-2015-29题

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_name 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. The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table列数对不上
C. The WHERE clause cannot be used in a sub query embedded嵌入 in an INSERT statement
D. Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match列名在两表中不符合。
Answer: A
Explanation:
Copying Rows from Another Table Write your INSERT statement with a subquery:
Do not use the VALUES clause.values后面不能跟子查询，或者直接不要VALUES 。不然会报错：

ORA-00936: missing expression

Match the number of columns in the INSERT clause to those in the subquery.
Inserts all the rows returned by the subquery in the table, sales_reps.