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?

995

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?

1005

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

1005

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

1207

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?

1023

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

995

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

1089

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

938

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?

1084

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

1048

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

979

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

1011

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

1116

Where is the myisam table stored?

1012

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

1032

Post New MySQL Questions

Un-Answered Questions { MySQL }

Does mysql automatically index foreign keys?

981

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

1091

How to create a table index in mysql?

1017

Do I need python for mysql?

979

Which is better mysql or mssql?

986

How do I change a procedure in mysql?

1063

what is cte? : Mysql dba

1000

What is mysql cursor?

938

What is mysql database used for?

1095

What is text in mysql?

963

How will you export tables as an xml file in mysql?

973

What is mysql connector used for?

995

How do I kill a mysql query?

959

What is mysql vs sql?

1042

Write a command to view mysql database table structure?

1017

For More Un-Answered { MySQL } Questions Click Here