Lab 6.1 Self-Review Questions


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

1)

A CASE construct is a control statement for which of the following?

  1. _____ Sequence structure

  2. _____ Iteration structure

  3. _____ Selection structure

2)

The ELSE clause is required part of a CASE construct.

  1. _____ True

  2. _____ False

3)

A selector in a CASE statement

  1. _____ is evaluated as many times as there are WHEN clauses.

  2. _____ is evaluated once per CASE statement.

  3. _____ is not evaluated at all.

4)

When all conditions of the searched CASE construct evaluate to NULL

  1. _____ Control is passed to the first executable statement after END CASE if there is no ELSE clause present.

  2. _____ Control is passed to the first executable statement after END CASE if there is an ELSE clause present.

  3. _____ CASE statement causes a syntax error if there is no ELSE clause present.

5)

CASE statements cannot be nested one inside the other

  1. _____ False

  2. _____ True


Answers appear in Appendix A, Section 6.1 .



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