Oracle® PL/SQL® Interactive Workbook, Second Edition

Chapter 19 Records

Lab 19.1 ▪ Self-Review Answers

A1:	Questions Answers Comments 1) C %ROWTYPE means “based on a row.” This row may be based on a database table row or on a row returned by a cursor.
A2:	Questions Answers Comments 2) C When a field with a NOT NULL constraint is not initialized, a user-defined record causes an error.
A3:	Questions Answers Comments 3) B You are able to assign a table-based record to a cursor-based record and vice versa. This restriction applies to user-defined records that have the same structure yet different data types.
A4:	Questions Answers Comments 4) A An aggregate assignment statement between two user-defined records causes an error where the records are not based on the same type.
A5:	Questions Answers ...