Oracle
1Z0-061 · Question #275
1Z0-061 Question #275: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #275. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the structure of the PRODUCTS, SALES, and SALE_SUMMARY tables. SALE_VW is a view created using the following command: SQL>CREATE VIEW sale_vw AS SELECT prod_id, SUM(quantity_sold) QTY_SOLD FROM sales GROUP BY prod_id; You issue the following command to add a row to the SALE_SUMMARY table: SQL>INSERT INTO sale_summary SELECT prod_id, prod_name, qty_sold FROM sale_vw JOIN products USING (prod_id) WHERE prod_id = 16; What is the outcome?
Options
- AIt executes successfully.
- BIt gives an error because a complex view cannot be used to add data into the SALE_SUMMARY
- CIt gives an error because the column names in the subquery and the SALE_SUMMARY table do
- DIt gives an error because the number of columns to be inserted does not match with the number of
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 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.