nerdexam
Oracle

1Z0-082 · Question #29

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

The correct answer is B. A table row piece can be chained across several database blocks C. Multiple row pieces from the same row may be stored in different database blocks E. Data block free space is always contiguous in the middle of the block. See the full explanation below for the reasoning.

Storage Structures

Question

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

Options

  • AData block headers contain their own Data Block Address (DBA)
  • BA table row piece can be chained across several database blocks
  • CMultiple row pieces from the same row may be stored in different database blocks
  • DMultiple row pieces from the same row may be stored in the same block
  • EData block free space is always contiguous in the middle of the block
  • FIndex block free space is always contiguous in the middle of the block

How the community answered

(48 responses)
  • A
    4% (2)
  • B
    85% (41)
  • D
    2% (1)
  • F
    8% (4)

Topics

#data blocks#row chaining#block structure#free space management

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice