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?

911

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?

920

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

894

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

1089

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?

926

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

886

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

984

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

844

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?

964

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

917

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

858

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

910

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

982

Where is the myisam table stored?

903

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

910

Post New MySQL Questions

Un-Answered Questions { MySQL }

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

840

Is mysql deprecated?

862

What is the difference between database and table?

959

How to delete an existing column in a table?

887

suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

2075

What is the default port number of mysql?

892

How to check server status with 'mysqladmin'?

1087

What is prepare statement in mysql?

924

What does mysqli stand for?

876

What is the datatype for password in mysql?

926

How do you stop an access query?

855

What is difference between mysql and mysql server?

938

How do I view mysql logs?

834

What is mysql in dbms?

940

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

980

For More Un-Answered { MySQL } Questions Click Here