What could be the reason?

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?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *