Examine the description of the PRODUCT_STATUS table:The STATUS column contains the values 'IN STOCK' or...

Oracle 1z0-071 Question Answer

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 prod_id "CURRENT AVAILABILITY" || q'('s not available)' FROM product_status WHERE status = ’OUT OF STOCK';

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

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

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

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

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

1z0-071 PDF/Engine

Get 60% Discount on All Products, Use Coupon: "8w52ceb345"