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?

852

How to determine the location of the data directory?

914

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

1049

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

849

How would concatenate strings in mysql?

966

What is difference between mysql_connect and mysql_pconnect?

979

what is the procedure to configure the application of mysql?

972

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

934

Write a query to stop mysql in unix

1002

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

878

What are enums used for in mysql?

958

How database are managed?

943

When to use order by in delete statement?

981

Why to use char instead of varchar in the database?

1104

How can you make a database as your current database?

966

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is the data source name for mysql?

898

What is insert query in mysql?

854

Can we save images in mysql database?

848

Is mysql query case sensitive?

910

What is the difference between truncate and delete?

1119

How is data stored in mysql?

874

What is int mysql?

895

Where is mysql password stored?

885

What is the maximum number of records in mysql table?

860

Is mysqli secure?

842

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.

946

Can you tell the difference between ereg_replace() and eregi_replace()?

992

Write a query to display even rows in student table using mysql?

854

What is a mysql server?

936

How do I install mysql on windows 7?

951

For More Un-Answered { MySQL } Questions Click Here