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?

951

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?

946

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()?

1036

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

889

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?

1019

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

988

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?

971

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is pdo connection?

879

How do we use % when performing a search query?

913

How to create trigger in mysql workbench?

996

How does php communicate with mysql?

910

Why we use mongodb instead of mysql?

968

Is mysql a server or database?

905

How to get data from mysql in php?

901

Define REGEXP?

1106

How can you import tables from a sql file into a database by using the mysql client?

1036

What is mysql default database?

1001

what is database white box testing? : Mysql dba

998

What is the query to display top 20 rows?

1018

Does mysql support sequence?

942

How do I delete a mysql user?

847

What are the differences between innodb and myisam engines?

979

For More Un-Answered { MySQL } Questions Click Here