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

MySQL Interview Questions

Questions Answers Views Company eMail

What are some good ideas regarding user security in MySQL?

2 5274

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9952

What does myisamchk do?

1 4555

Explain advantages of InnoDB over MyISAM?

1 8355

Explain advantages of MyISAM over InnoDB?

1 6598

What are HEAP tables in MySQL?

1 13060

How do you control the max size of a HEAP table?

1 9090

What are CSV tables?

1 6305

Explain federated tables?

Tech Mahindra,

3 9256

What is SERIAL data type in MySQL?

Aspire,

3 48370

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

2 12500

If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?

ABC,

2 6406

Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE CURRENT_TIMESTAMP.

1 3877

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 5413

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 10394

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is a join? Explain the different types of mysql joins.

1464

What is a heap table?

1028

How do I view tables in mysql workbench?

975

What are the three types of queries?

963

What do you need to connect php to mysql?

1040

How do I tune a mysql query?

946

Where is mysql used?

1038

Is mysql distributed?

984

I want to start and stop mysql on windows? How do I do that?

1116

What tools available for managing mysql server?

1083

Consider you have the following three tables which have to be linked together.

944

What is mysql cursor?

938

What is mysql vs sql?

1042

Can a table have multiple primary keys?

953

How to shutdown mysql server?

1137

For More Un-Answered { MySQL } Questions Click Here