1Z0-873 Question #30: Real Exam Question with Answer & Explanation

The correct answer is A. All rows have the same size. C. Rows are easy to look up. E. Row data usually takes up more space on disk and in memory.. Fixed-row format: All rows have the same size. Rows are stored within the table at positions that are multiples of the row size, making them easy Fixed-size rows take more space. Dynamic-row format: Rows take varying amounts of space. Rows cannot be looked up as efficiently. Dyna

Question

Which of the following are characteristics of the MyISAM fixed-row storage format as compared to the dynamic row format?

Options

AAll rows have the same size.
BRows take varying amounts of space.
CRows are easy to look up.
DRows cannot be looked up as efficiently.
ERow data usually takes up more space on disk and in memory.

Explanation

Fixed-row format: All rows have the same size. Rows are stored within the table at positions that are multiples of the row size, making them easy Fixed-size rows take more space. Dynamic-row format: Rows take varying amounts of space. Rows cannot be looked up as efficiently. Dynamic-rows tables usually take less space because rows are not padded to a fixed size. Fragmentation can occur more easily than for fixed-row tables.

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice