Oracle Database Administration I — Question 139

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

Answer options

• A. An index block can contain row data.
• B. A data block header is of a fixed length.
• C. Row data is stored starting at the end of the block.
• D. A table block must always contain row data.
• E. A block header contains a row directory pointing to all rows in the block.

Correct answer: A, C, E

Explanation

Options A, C, and E are correct because an index block can indeed contain row data, row data starts at the end of the block, and the block header does have a row directory for tracking rows. Options B and D are incorrect as the data block header can vary in size and a table block does not have to always contain row data.