Given the following query:
SELECT quantity,
CASE WHEN itemcode = ‘099’ THEN ‘SILVER’
WHEN itemcode = ‘788’ THEN ‘GOLD’
WHEN itemcode = ‘899’ THEN ‘PLATINUM’
ELSE ‘ERROR’
END
FROM supplier
What will be the result of the query if the following data is evaluated by the CASE expression?
SUPPLIER
——————————————
QUANTITY ITEMCODE
3 099
4 099
1 788
1 899
5 009
3 788
1 899
A. 3,SILVER4,GOLD1,SILVER1,GOLD5,PLATINUM3,SILVER1,GOLD
B. 3,SILVER4,SILVER1,GOLD1,PLATINUM5,ERROR3,GOLD1,PLATINUM
C. 3,SILVER4,SILVER1,PLATINUM1,ERROR5,SILVER3,GOLD1,PLATINUM
D. 3,SILVER4,SILVER1,GOLD1,GOLD5,SILVER3,ERROR1,PLATINUM
|
Download Printable PDF. VALID exam to help you PASS. |
 |