Oracle Database 12c: Installation and Administration — Question 116

Which two are true about database table rows? (Choose two.)

Answer options

• A. They always have a row header.
• B. They are always stored in a single database block.
• C. They are chained across multiple blocks only when the table has more than 255 columns.
• D. They have a row header only when they are chained across multiple database blocks.
• E. They can be stored in a single database block.

Correct answer: C, E

Explanation

Option C is correct because rows are only chained across multiple blocks when there are more than 255 columns, which is a specific condition. Option E is also correct as rows can indeed be stored within a single database block. The other options are incorrect because rows do not always have a row header, and they can be stored in more ways than just a single block.