I

DB2 9 Family Fundamentals

300 Questions

You can start the exam to practice all questions related to this exam.

Question No. 1

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
 

Choose the correct option from the given list.
01 / 300

0 Discussions

Trending Exams