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