In order to test your progress, you should be able to answer the following questions.
A CASE expression
_____ returns a single value.
_____ returns multiple values.
_____ does not return values at all
A CASE expression is terminated by
_____ END CASE.
_____ CASE.
_____ END.
A CASE expression never has a selector.
_____ True
_____ False
When all conditions of a CASE expression evaluate to NULL, the expression
_____ returns NULL if there is no ELSE clause present.
_____ causes a syntax error if there is no ELSE clause present.
A CASE expression may return a single datatype only.
Answers appear in Appendix A, Section 6.2 .