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?

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?

Accepted Answer

D. It gives an error because the number of columns to be inserted does not match with the number of

Answer

A. It executes successfully.

Answer

B. It gives an error because a complex view cannot be used to add data into the SALE_SUMMARY

Answer

C. It gives an error because the column names in the subquery and the SALE_SUMMARY table do

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…

Question

Options

How the community answered

Community Discussion