View the Exhibits and examine products and sales tables. You issue the following query to display product name and the number of times the product has been sold: What happens when the above…

Question

Exhibits

Options

• AThe statement executes successfully and produces the required output.
• BThe statement produces an error because item_cnt cannot be displayed in the outer query.
• CThe statement produces an error because a subquery in the from clause and outer-joins cannot
• DThe statement produces an error because the group by clause cannot be used in a subquery in

• A
  78% (18)
• B
  13% (3)
• C
  4% (1)
• D
  4% (1)

No community discussion yet for this question.