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

MySQL Interview Questions

Questions Answers Views Company eMail

What is normalization and list the different types of normalization?

948

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

959

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

944

What is the command used to create a database using php and mysql?

1147

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

975

How can you handle the –secure-file-priv in mysql?

946

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

1035

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

887

Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

1016

What are the ways in which you can retrieve data in the result set of mysql using php?

987

Can you tell few best practices to be followed for optimization in sql?

900

How can you take the backup and restore a mysql database using php?

960

How to copy data from one server to another using php?

1046

Where is the myisam table stored?

965

Can you tell the difference between $message and $$message?

970

Post New MySQL Questions

Un-Answered Questions { MySQL }

What are procedures in mysql?

950

How do I install mysql workbench?

905

Write a query to count the number of rows of a table in mysql.

935

How to declare variable in mysql trigger?

1011

What is meant by mysqli?

900

How do I create a stored procedure in mysql?

900

What is difference between mysql and mysql workbench?

954

Which is best pdo or mysqli?

918

What is blob and text in mysql?

1172

How to store values to array from mysql database in php?

944

What is difference between group by and order by clause?

964

what is constraints? Also explain the different types of constraints?

971

How can you find out the version of the installed mysql?

1315

Is mysql a good database?

947

what is a cursor? : Mysql dba

1020

For More Un-Answered { MySQL } Questions Click Here