View the Exhibit and examine the structure of the CUSTOMERS table.NEW_CUSTOMERS is a new table with the columns CUST_ID,
Posted: Wed Jun 07, 2023 6:12 am
View the Exhibit and examine the structure of the CUSTOMERS table.NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME andCUST_CITY that have the same data types and size as the corresponding columns in theCUSTOMERS 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
- View The Exhibi 1 (78.96 KiB) Viewed 168 times
- View The Exhibi 2 (1.65 KiB) Viewed 168 times
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