Examine the description of the PRODUCT_STATUS table: The status column contains the values 'in stock' or 'out of stock' for each row. Which two queries will execute successfully?

Question

Options

• ASELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';
• BSELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';
• CSELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status
• DSELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status
• ESELECT prod_id I I q' ('s not available) ?'CURRENT AVAILABILITY' FROM product_status
• FSELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;

• A
  3% (1)
• B
  79% (27)
• C
  3% (1)
• E
  9% (3)
• F
  6% (2)

No community discussion yet for this question.