1Z0-061 · Question #14
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…
The correct answer is A. The values clause cannot be used in an INSERT with a subquery. Copying Rows from Another Table Write your INSERT statement with a subquery: Do not use the VALUES clause. Match the number of columns in the INSERT clause to those in the subquery. Inserts all the rows returned by the subquery in the table, sales_reps.
Question
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?
Exhibit
Options
- AThe values clause cannot be used in an INSERT with a subquery.
- BColumn names in the NEW_CUSTOMERS and CUSTOMERS tables do not match.
- CThe where clause cannot be used in a subquery embedded in an INSERT statement.
- DThe total number of columns in the NEW_CUSTOMERS table does not match the total number of
How the community answered
(29 responses)- A72% (21)
- B17% (5)
- C3% (1)
- D7% (2)
Explanation
Copying Rows from Another Table Write your INSERT statement with a subquery: Do not use the VALUES clause. Match the number of columns in the INSERT clause to those in the subquery. Inserts all the rows returned by the subquery in the table, sales_reps.
Topics
Community Discussion
No community discussion yet for this question.