Oracle PL[s]SQL by Example

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 .

Related

Категории