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’;

Xem thêm:

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