Exit 1Z0-051 Oracle Database 11g : SQL Fundamentals I
Question 3 of 5
0% complete
Q3 Single choice

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

Previous Next