MySQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MySQL Interview Questions

Questions Answers Views Company eMail

What is a storage engine?

953

What is a join? Explain the different types of mysql joins.

1 1384

What is the purpose of using a heap table?

1107

How can you change the password of a mysql user?

955

How can you calculate the sum of any column of a table?

1044

What is meant by decimal (5,2)?

1015

What is a trigger? How you can create a trigger in mysql?

893

What is the difference between unix timestamp and mysql timestamp?

1049

How can you change the name of any existing table by using the sql statement?

994

What is the purpose of using ifnull() function?

959

How can you add and remove any column of a table?

936

How can you export the table as an xml file in mysql?

877

How can you create and drop view in mysql?

916

What is an index? How can an index be declared in mysql?

888

What are the differences between a primary key and foreign key?

1087

Post New MySQL Questions

Un-Answered Questions { MySQL }

How do I install mysql workbench?

899

How to returns the columns and column information pertaining to the designated table.

1017

How do I show users in mysql?

1045

If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

933

Is sql and mysql same?

920

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2823

What are string data types?

1025

Which software is used for mysql?

976

Is mysql owned by oracle?

1007

Can a table have multiple primary keys?

894

What is mysql architecture?

1000

What is the function of mysqldump?

1068

How do I grant privileges to a user in mysql phpmyadmin?

948

Create table employee (eno int(2),ename varchar(10)) ?

1001

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

923

For More Un-Answered { MySQL } Questions Click Here