View the Exhibit and examine the structure of the promotions table. Evaluate the following SQL statement: Which statement is true regarding the outcome of the above query?

Question

Exhibits

Options

• AIt shows COST_REMARK for all the promos in the table.
• BIt produces an error because the SUBQUERY gives an error.
• CIt shows COST_REMARK for all the promos in the promo category 'TV'
• DIt produces an error because SUBQUERIES cannot be used with the case expression.

• A
  71% (37)
• B
  15% (8)
• C
  10% (5)
• D
  4% (2)

No community discussion yet for this question.