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)- A4% (2)
- B85% (41)
- D2% (1)
- F8% (4)
Topics
#data blocks#row chaining#block structure#free space management
Community Discussion
No community discussion yet for this question.