View the Exhibits and examine PRODUCTS and SALES tables. Exhibit 1 Exhibit 2 You issue the following query to display product name the number of times the product has been sold: What happens when…

Question

Exhibits

Options

• AThe statement executes successfully and produces the required output.
• BThe statement produces an error because a subquery in the FROM clause and outer-joins cannot
• CThe statement produces an error because the GROUP BY clause cannot be used in a subquery
• DThe statement produces an error because ITEM_CNT cannot be displayed in the outer query.

• A
  73% (29)
• B
  15% (6)
• C
  5% (2)
• D
  8% (3)

No community discussion yet for this question.