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

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?

1019

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?

971

Post New MySQL Questions

Un-Answered Questions { MySQL }

Is postgresql better than mysql?

1034

What is mysql good for?

895

How to create and drop view in mysql?

915

What is the difference between myisam dynamic and myisam static in mysql?

1013

How to dump one database for backup.

938

How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

1064

How many rows can a mysql table hold?

1017

How to write after insert event update trigger on the same table in mysql?

957

What is a storage engine? What are the differences between innodb and myisam engines?

1067

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

906

In which language mysql has been written?

1336

What is limit in mysql?

868

How do I exit mysql?

917

How do I delete a table in mysql workbench?

1037

What does do in mysql?

877

For More Un-Answered { MySQL } Questions Click Here