Prentice Hall Oracle Plsql By Example 3Rd Edition [Electronic resources]

Benjamin Rosenzweig

نسخه متنی -صفحه : 289/ 216
نمايش فراداده

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

  • _____ table-based records only.

  • _____ cursor-based records only.

  • _____ table-based and cursor-based records.

  • 2)

    When creating a user-defined record, you must

  • _____ initialize all of its fields.

  • _____ initialize at least one of its fields.

  • _____ 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.

  • _____ True

  • _____ False

  • 4)

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

  • _____ True

  • _____ False

  • 5)

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

  • _____ True

  • _____ False

  • Answers appear in Appendix A,

    Section 19.1 .