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 5058

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9789

What does myisamchk do?

1 4396

Explain advantages of InnoDB over MyISAM?

1 8184

Explain advantages of MyISAM over InnoDB?

1 6426

What are HEAP tables in MySQL?

1 12886

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

1 8927

What are CSV tables?

1 6156

Explain federated tables?

Tech Mahindra,

3 8973

What is SERIAL data type in MySQL?

Aspire,

3 47953

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

2 12284

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

ABC,

2 6176

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

1 3558

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 5224

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 10189

Post New MySQL Questions

Un-Answered Questions { MySQL }

How to check if a record exists in a mysql database php?

843

What is difference between inner vs self vs cross?

913

What is pragma autonomous_transaction?

824

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

940

Does uninstalling mysql delete database?

955

What is the default port number of mysql?

895

How to Join tables on common columns.

1113

How can you retrieve a portion of any column value by using a select query?

873

What do you need to connect php to mysql?

941

What is mysql in linux?

961

How do you stop an access query?

862

What is a crosstab query?

909

How do I fix a crashed mysql database?

901

How to determine the location of the data directory?

914

Where is the myisam table stored?

904

For More Un-Answered { MySQL } Questions Click Here