Lab 19.2 Self-Review Questions


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

1)

A record is called a nested record if it contains

  1. _____ other records.

  2. _____ collections.

  3. _____ all of the above

  4. _____ none of the above

2)

When creating a nested record, you are allowed to nest only a single record or a single collection.

  1. _____ True

  2. _____ False

3)

When creating a nested record, you must initialize

  1. _____ all of the fields of the enclosing record.

  2. _____ at least one of the fields of the enclosing record.

  3. _____ a field of the enclosing record only if there is a NOT NULL constraint defined in it.

4)

It is illegal to declare a record field as an index-by table.

  1. _____ True

  2. _____ False

5)

It is illegal to declare a record field as a varray.

  1. _____ True

  2. _____ False


Answers appear in Appendix A, Section 19.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