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

MySQL Interview Questions

Questions Answers Views Company eMail

Write a query to create a database and a table?

902

How to determine the location of the data directory?

959

What is the purpose of -> in the mysql terminal?

1119

What you can use regular expression for in mysql? Support your answer with an example?

914

How would concatenate strings in mysql?

1032

What is difference between mysql_connect and mysql_pconnect?

1041

what is the procedure to configure the application of mysql?

1040

Where’s database data actually stored? Is there a way to see the files which are stored?

982

Write a query to stop mysql in unix

1051

What does the file with the extension: frm, myd, and myi contain?

924

What are enums used for in mysql?

1003

How database are managed?

990

When to use order by in delete statement?

1020

Why to use char instead of varchar in the database?

1189

How can you make a database as your current database?

1050

Post New MySQL Questions

Un-Answered Questions { MySQL }

What are views in mysql?

929

What do you mean by % and _ in the LIKE statement?

985

Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

993

What is orm in mysql?

906

How do you name a table?

895

What is the usage of ENUMs in MySQL?

1132

What is mysql database extension?

1029

How will show all records containing the name "sonia" and the phone number '9876543210'

906

How do I install mysql?

910

How you can create a trigger in mysql?

1000

How do I find the size of a mysql database?

913

What is required to create mysql database?

985

What is username in mysql?

897

What is a left join mysql?

901

How can we convert between Unix & MySQL timestamps?

967

For More Un-Answered { MySQL } Questions Click Here