Identify two situations in which the block header grows in a data block. (Choose two.)

Identify two situations in which the block header grows in a data block. (Choose two.)

Identify two situations in which the block header grows in a data block. (Choose two.)

A.
When row directories need more row entries

B.
When there is row migration in the data block

C.
When there is an increase in the PCTFREE value for the data block

D.
When more transaction slots are required than are initially configured



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Sagar Sable

Sagar Sable

When row directories need more row entries:
each row entry is recorded in data blocks. even if we delete row without commiting row entry goes up n up. so data block header take space from data block.

When more transaction slots are required than are initially configured:
all info like locks on rows stored in header so when more slots require more space used from header.