Q137 The status column contains the values ‘in stock’ or ‘out of stock’ for each row

Q137 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?

• (A). SELECT prod_id Il q”‘s not available” FROM product_status where status = ‘OUT OF STOCK’;
• (B). SELECT prod_id II q'(‘s not available)’ FROM product_status WHERE status = ‘OUT OF STOCK’;
• (C). SELECT prod_id “CURRENT AVAILABILITY” II q'<‘s not available)’ FROM product_status WHERE status = ‘OUT OF STOCK’;
• (D). SELECT prod_id I I q’ (‘s not available)’ “CURRENT AVAILABILITY” FROM product_status WHERE status = ‘OUT OF STOCK’;
• (E). SELECT prod_id I I q’ (‘s not available) * ‘CURRENT AVAILABILITY’ FROM product_status WHERE status = ‘OUT OF STOCK’;
• (F). SELECT prod_id q’s not available” FROM product_status WHERE status = ‘OUT OF STOCK’;