21. How do you control the max size of a HEAP table? Maximum size of Heal table can be controlled by MySQL config variable called max_heap_table_size. 22. What is the difference between MyISAM Static and MyISAM Dynamic? In MyISAM static…