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 5912

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

1 5885

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

2 7518

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 75199

Explain the difference between BOOL, TINYINT and BIT?

1 6193

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

4099

Explain MySQL architecture?

1 13599

Explain MySQL locks?

1 5238

Explain multi-version concurrency control in MySQL?

2 9807

What are MySQL transactions?

2 5438

What is ACID?

2 5937

Which storage engines support transactions in MySQL?

2 7659

How do you convert to a different table type?

1 4083

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

2 5172

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

Aufait, CSS, Wipro,

4 14723

Post New MySQL Questions

Un-Answered Questions { MySQL }

How do I edit a trigger in mysql?

893

Is mysql and sql are same?

1071

What is the difference between unix timestamps and mysql timestamps?

1015

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

1013

What is unsigned in mysql?

936

How to get a version of mysql?

1044

How do I rename a procedure?

882

What is the use of i-am-a-dummy flag in mysql?

1011

How do I make an action query?

932

How do I find users in mysql?

1104

How to set mysql variable in php?

927

Which is better sqlite or mysql?

1041

Where is the myisam table stored?

965

What is innodb_buffer_pool_size?

980

Can a table have multiple primary keys?

902

For More Un-Answered { MySQL } Questions Click Here