Oracle PL[s]SQL by Example

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 .

Related

Категории