Lab 19.1 Self-Review Questions


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

1)

The %ROWTYPE attribute allows you to specify

  1. _____ table-based records only.

  2. _____ cursor-based records only.

  3. _____ table-based and cursor-based records.

2)

When creating a user -defined record, you must

  1. _____ initialize all of its fields.

  2. _____ initialize at least one of its fields.

  3. _____ initialize a field only if there is a NOT NULL constraint defined in it.

3)

An aggregate assignment statement will cause an error if table-based and cursor-based records have the same structure.

  1. _____ True

  2. _____ False

4)

An aggregate assignment statement will cause an error if two user-defined records have the same structure yet different types.

  1. _____ True

  2. _____ False

5)

An aggregate assignment statement will cause an error if table-based and user-defined records have the same structure.

  1. _____ True

  2. _____ False


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