Oracle Database Administration I — Question 164

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

Answer options

• A. Multiple row pieces from the same row may be stored in different database blocks.
• B. Index block free space is always contiguous in the middle of the block.
• C. A table row can be chained across several database blocks.
• D. Multiple row pieces from the same row must be stored in different database blocks.
• E. Data block free space is always contiguous in the middle of the block.

Correct answer: A, C

Explanation

Option A is correct because it is possible for different pieces of a single row to be stored across multiple database blocks. Option C is also correct as a table row can be divided and stored over several blocks. Options B, D, and E are incorrect because they misrepresent the characteristics of free space and row storage in Oracle Database.