Oracle Database Administration I — Question 39

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

Answer options

• A. Data block headers contain their own Data Block Address (DBA)
• 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
• D. Multiple row pieces from the same row may be stored in the same block
• E. Data block free space is always contiguous in the middle of the block
• F. Index block free space is always contiguous in the middle of the block

Correct answer: A, C, D

Explanation

Option A is correct because data block headers do contain their own Data Block Address (DBA), which is essential for data retrieval. Options C and D are also correct as they describe the flexibility of row piece storage in database blocks. Options B, E, and F are incorrect; B is wrong because row pieces are typically stored in a single block, while E and F are incorrect as free space can be fragmented rather than always contiguous.