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 4629

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9470

What does myisamchk do?

1 4072

Explain advantages of InnoDB over MyISAM?

1 7846

Explain advantages of MyISAM over InnoDB?

1 6082

What are HEAP tables in MySQL?

1 12479

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

1 8535

What are CSV tables?

1 5765

Explain federated tables?

Tech Mahindra,

3 8284

What is SERIAL data type in MySQL?

Aspire,

3 46975

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

2 11825

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

ABC,

2 5685

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

1 3236

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 4827

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 9550

Post New MySQL Questions

Un-Answered Questions { MySQL }

What are numeric data types?

707

How do I edit a table in mysql?

654

What is a table schema?

729

using primary can we relate two table, with out foreign key?

2464

Can you tell a way to know the number of days between the two given dates in php?

773

What is mysql ndb?

681

What is the use of mysqli_fetch_assoc?

658

How can you export the table as an xml file in mysql?

674

What are the functions used to encrypt and decrypt the data present in mysql?

720

How do I clear a mysql database?

697

What is row level locking in access?

649

How to display top 10 rows in mysql?

736

How important is to list the column names when doing an insert?

760

Explain what is mysql?

782

How to shut down the server with 'mysqladmin'?

710

For More Un-Answered { MySQL } Questions Click Here