MySQL Interview Questions And Answers

Prem Tiwari - - Interview Questions Answer


This page contains the list commonly asked MySQL interview questions and answers. MySQL is an open-source relational database management system (RDBMS) owned by Oracle, though initially owned and sponsored by a single for-profit firm, the Swedish company MYSQLAB. The complete source code of MySQL is accessible under the GNU General Public License terms.

MySQL Interview Questions And Answers

Q1: In which language MySQL is developed?
MySQL is developed in C & C++ and its SQL parser is written in yacc programming language.


Q2: What is Technical Specification of MySQL?
Below are the technical specification of MySQL database:

  • High performance
  • Flexible structure
  • Replication and high availability
  • Security and storage management
  • Easy to manage and use

Q3: How to display the current date and time using MySQL Query?
Use the below MySQL query to display the current date and time:

Below query will display only date:


Q4: What is limitation to add columns to create for an index?
You can create maximum of 16 indexed columns for a standard MySQL table.


Q5: How do you create an alias in MySQL?
Use the below MySQL query to create an alias in MySQL database:


Q6: What is default port for MySQL Server?
The default port of MySQL server is 3306.


Q7: How can you dispaly the all indexes defined for a database table?
Use the below MySQL query to display the all nindexes defined for a database table:


Q8: What is InnoDB?
The InnoDB is a database storage engine used for the safe database transactions. It was developed by Inno Oy, now Oracle Corporation.


Q9: How many types of JOINS in MySQL?
Below are the list of joins which you can used in MySQL:
1) Inner join
1.1) equi join
1.2) natural join

2)Outer join

2.1)left join
2.2)right join
2.3) full join

3) Cross join


Q10: How to get only the distinict columns values in MySQL?
Use the MySQL query to get only the distinict columns values from table:


Q11: How many TRIGGERS are possible in MySQL?
There are six type of triggers to use in MySQL database table.

  1. Before Insert
  2. After Insert
  3. Before Update
  4. After Update
  5. Before Delete
  6. After Delete

Q12: How to concatenate two fields in MySQL?
Use the below MySQL query to concatenate two fields in MySQL:


Q13: List out the storage engines which MySQL support?
Below is the list of storage engines which MySQL support:

  1. MyISAM
  2. InnoDB
  3. Memory
  4. CSV
  5. Merge

Q14: How do you get a portion of a string?
Use the below MySQL query to get a portion of a string:


Q15: How do you convert a string to UTF-8?
Use the below MySQL query to convert a string to UTF-8 using MySQl query:



About: Prem Tiwari

Prem Tiwari is the founder of FreeWebMentor.com and also a professional developer who has vast experience in PHP and open source technologies. Apart from this, he is a blogger by hobby and also he has been a regular speaker of WordPress sessions in various IT Companies.