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:
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.