Examine the description of the PRODUCR STATUS table
Name Null type
-----------------------------------------------------
PROD_ID NOT NULL NUMBER(2)
STATUS NOT NULL VARCHAR2(15)
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 || q ' ('s not availablE.' from product status WHERE status = 'OUT
OF STOCK'
B.SELECT prod_id || q ' ('s not availablE.' "CURRENT AVAILABILITY"FROM
Product status WHERE status = 'OUT OF STOCK '
C.SELECT prod_id "CURRENT AVAILABILITY" || q ' ('s not availablE.'from
Product status WHERE status = 'OUT OF STOCK'
D.SELECT prod id || q('s not availablE.' 'current AVAILABILITY ' FROM
Product status WHERE status = 'OUT OF STOCK'
E.SELECT prod id q 's not available" FROM product status WHERE status ="OUT OF
STOCK"
F.SELECT prod id || q" 's not available" FROM product_status WHERE status = 'OUT OF
STOCK'
正确答案AB 