CREATE TABLE `rftst` ( `a` char(8) default NULL, `b` int(11) NOT NULL auto_increment, `c` decimal(10,2) default NULL, PRIMARY KEY (`b`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
a) Fixed b) Dynamic c) Compact d) Redundant
[ Tables and Indexes (15%) - Table Properties ]
Answer:
a
That’s because all columns have a constant length.
If you’d add for example a varchar field, then the rowtype changes to dynamic.
c and d are innodb row-formats.