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

MySQL Interview Questions

Questions Answers Views Company eMail

what if you really want to store the timestamp data, such as the publication date of the article?

2 5416

What happens if a table has one column defined as TIMESTAMP?

1 5529

If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?

2 7048

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 72853

Explain the difference between BOOL, TINYINT and BIT?

1 5782

How to enable or disable a row of a table using MySQL in struts?

3842

Explain MySQL architecture?

1 13223

Explain MySQL locks?

1 4883

Explain multi-version concurrency control in MySQL?

2 9181

What are MySQL transactions?

2 4939

What is ACID?

2 5461

Which storage engines support transactions in MySQL?

2 7134

How do you convert to a different table type?

1 3711

How do you index just the first four bytes of the column?

2 4649

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

Aufait, CSS, Wipro,

4 13801

Post New MySQL Questions

Un-Answered Questions { MySQL }

Can mysql handle billions of records?

762

How can we convert between Unix & MySQL timestamps?

668

How to represent ENUMs and SETs internally?

911

How do I delete a row in mysql?

720

What is difference between mysql mysqli and pdo?

660

How to Set a root password if there is on root password.

801

Is mysql connect deprecated?

726

How to enter binary numbers in sql statements?

741

What is difference between microsoft sql and mysql?

691

How to decrement dates by 1 in mysql?

757

Is sqlite faster than mysql?

691

What is the use of pdo?

732

What are the other commands to know the structure of a table using mysql commands except explain command?

747

How do I view data in mysql workbench?

741

What is query design?

675

For More Un-Answered { MySQL } Questions Click Here