1Z0-071 Web TestEngine demo

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?

Select all that apply.

• A

  SELECT prod_id "CURRENT AVAILABILITY" || q'('s not available)' FROM product_status WHERE
  status = 'OUT OF STOCK';

• B

  SELECT prod_id || q's not available'' FROM product_status WHERE status='OUT OF STOCK';

• C

  SELECT prod_id || q'('s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE
  status = 'OUT OF STOCK';

• D

  SELECT prod_id || q'('s not available)' FROM product_status WHERE status = 'OUT OF STOCK';

• E

  SELECT prod_id || 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';