Oracle
1Z0-047 · Question #110
1Z0-047 Question #110: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #110. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the structure of the ORDERS table. NEW_IDRDERS is a new table with the columns ORD_ID, ORD_DATE, CUST_ID, and ORD_TOTAL that have the same data types and size as the corresponding columns in the ORDERS table. Evaluate the following INSERT statement: INSERT INTO new_orders (ord_id, ord_date, cust_id, ord_total) VALUES(SELECT order_id.order_date.customer_id.order_total FROM orders WHERE order_date > `31-dec-1999'); Why would the INSERT statement fail?
Options
- Abecause column names in NEW_ORDERS and ORDERS tables do not match
- Bbecause the VALUES clause cannot be used in an INSERT with a subquery
- Cbecause the WHERE clause cannot be used in a subquery embedded in an INSERT statement
- Dbecause the total number of columns in the NEW_ORDERS table does not match the total number
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.