Maximum size of HEAP table can be controlled by MySQL config variable called max_heap_table_size.
What is the difference between MyISAM Static and MyISAM Dynamic?
In MyISAM static all the fields will have fixed width. The Dynamic MyISAM table will have fields like TEXT, BLOB, etc. to accommodate the data types with various lengths.
MyISAM Static would be easier to restore in case of corruption.
What are federated tables?
Federated tables which allow access to the tables located on other databases on other servers.
What, if a table has one column defined as TIMESTAMP?
Timestamp field gets the current timestamp whenever the row gets altered.
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
It stops incrementing. Any further inserts are going to produce an error, since the key has been used already.
What do you mean by % and _ in the LIKE statement?
% corresponds to 0 or more characters, _ is exactly one character in the LIKE statement.
How can we convert between Unix & MySQL time stamps?
UNIX_TIMESTAMP is the command which converts from MySQL time stamp to Unix time stamp
FROM_UNIXTIME is the command which converts from Unix time stamp to MySQL time stamp.