Chapter 19 Records


Lab 19.1 Self-Review Answers

A5:

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.

2)

C

When a field with a NOT NULL constraint is not initialized , a user -defined record causes an error.

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.

4)

A

An aggregate assignment statement between two user-defined records causes an error where the records are not based on the same type.

5)

B

A table-based record can be assigned to a user-defined record as long as they have the same structure. This restriction applies to user-defined records that have the same structure yet different data types.


Lab 19.2 Self-Review Answers

A5:

Questions

Answers

Comments

1)

C

 

2)

B

 

3)

C

You must initialize each field that has a NOT NULL constraint specified on it regardless of the record type.

4)

B

A nested record may contain any collection as one of its fields.

5)

B

 

Lab 19.3 Self-Review Answers

A5:

Questions

Answers

Comments

1)

B

 

2)

B

A varray has an upper bound that can be extended to its maximum size. The data type of its individual elements has no effect on how the upper bound is extended.

3)

B

You must always initialize a nested table regardless of its element type.

4)

B

You must always increase the size of a nested table before populating it with a new record regardless of its element type.

5)

B

You can use user-defined, table-based, or cursor-based records when creating a collection of records.




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