MySQL Interview questions

Total available count: 24
Subject - Databases
Subsubject - MySQL

Where MyISAM table will be stored and also give their formats of storage?

Each MyISAM table is stored on disk in three formats,

  1.  The ‘.frm’ file stores the table definition
  2.  The data file has a ‘.MYD’ (MYData) extension
  3. The index file has a ‘.MYI’ (MYIndex) extension

Next 5 interview question(s)

What is the difference between mysql_fetch_array and mysql_fetch_object?
What is the difference between BLOB AND TEXT?
Is Mysql query case sensitive?
How can you see all indexes defined for a table?
How do you login to MySql using Unix shell?