Lab 6.2 Self-Review Questions


In order to test your progress, you should be able to answer the following questions.

1)

A CASE expression

  1. _____ returns a single value.

  2. _____ returns multiple values.

  3. _____ does not return values at all

2)

A CASE expression is terminated by

  1. _____ END CASE.

  2. _____ CASE.

  3. _____ END.

3)

A CASE expression never has a selector.

  1. _____ True

  2. _____ False

4)

When all conditions of a CASE expression evaluate to NULL, the expression

  1. _____ returns NULL if there is no ELSE clause present.

  2. _____ causes a syntax error if there is no ELSE clause present.

5)

A CASE expression may return a single datatype only.

  1. _____ True

  2. _____ False


Answers appear in Appendix A, Section 6.2 .



Oracle PL[s]SQL by Example
Oracle PL[s]SQL by Example
ISBN: 3642256902
EAN: N/A
Year: 2003
Pages: 289

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net