MYSQL Interview Questions & Answers

Q : What are the advantages of mySQL comparing with oracle?
A : MySql are many advantages in comparison to Oracle.

1 - MySql is Open a source, which can be available any time

2 - MySql has no cost of development purpose.

3 - MySql has most of features , which oracle provides

4 - MySql day by day updating with the new facilities.

5 - Good for small application.

6 – Easy to learn and to become master.

7 - MySql has a good power these days.

Even though MySql having so many advantages, Oracle is best database ever in Software development.

Q : What are two examples of an OLTP environment?
A : The two expels of an OLTP environments are
On Line Banking
On Line Reservation (Transportation like Rail, Air etc.)

Q : What Is a Primary Key?
A : A primary key is a single column or multiple columns is defined to have unique values that can be used as a row identifications.

Q : What Is a Transaction?
A : A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server is introduced the transaction concept to allow users to group one or more SQL statements into a single transaction, so that the effects of all the SQL statements in a transaction can be either all committed (applied to the database) or all rolled back (undone from the database).

Q : What are the indexes?
A: An index is an internal structure which is provided quick access to rows of a table based on the values of more than one columns.


Q : What is a foreign key?
A: A foreign key is a constraint associates one or more columns in a table with an identical set of columns on which a primary key has been defined in another table. A foreign key may refer to the primary key of another table or same table.

Q : What is the difference between MyISAM Static and MyISAM Dynamic ?
A: In MyISAM static is all the fields have fixed width. The Dynamic MyISAM table would be include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even though you might lose some data, you know exactly where to look for the beginning of the next record.