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

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…

MySQL Storage Engines

Question

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.

How the community answered

(25 responses)

A
84% (21)
B
12% (3)
D
4% (1)

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.

Topics

#MyISAM row formats#fixed-row format#dynamic row format#storage efficiency

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice