nerdexam
Oracle

1Z0-052 · Question #75

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

The correct answer is A. When row directories need more row entries D. When more transaction slots are required than are initially configured. The block header in an Oracle data block can grow dynamically to accommodate more row directory entries or additional transaction slots beyond the INITRANS setting.

Managing Database Storage Structures

Question

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

Options

  • AWhen row directories need more row entries
  • BWhen there is row migration in the data block
  • CWhen there is an increase in the PCTFREE value for the data block
  • DWhen more transaction slots are required than are initially configured

How the community answered

(18 responses)
  • A
    72% (13)
  • B
    17% (3)
  • C
    11% (2)

Why each option

The block header in an Oracle data block can grow dynamically to accommodate more row directory entries or additional transaction slots beyond the INITRANS setting.

AWhen row directories need more row entriesCorrect

The row directory portion of the block header stores one entry (a pointer offset) for each row stored in the block; as more rows are inserted and the row directory runs out of pre-allocated entries, the block header expands into the free space area of the block to accommodate the new pointers.

BWhen there is row migration in the data block

Row migration occurs when an updated row no longer fits in its original block and Oracle moves the row to a new block, leaving only a forwarding pointer in the original block - this does not cause the original block header to grow.

CWhen there is an increase in the PCTFREE value for the data block

PCTFREE is a storage parameter that controls how much free space is reserved for future row updates; changing its value adjusts the threshold for when new inserts are allowed, but does not itself cause the block header to grow.

DWhen more transaction slots are required than are initially configuredCorrect

The Interested Transaction List (ITL) in the block header is initially sized by the INITRANS storage parameter; when concurrent transactions exceed the initial ITL slot count, Oracle dynamically allocates additional ITL entries by consuming free space from within the block, causing the block header to grow.

Concept tested: Oracle data block header growth - ITL and row directory

Source: https://docs.oracle.com/cd/E11882_01/server.112/e40540/logical.htm

Topics

#data block structure#block header#transaction slots#row directory

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice