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 5786

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

1 5789

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

2 7403

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 74565

Explain the difference between BOOL, TINYINT and BIT?

1 6088

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

4035

Explain MySQL architecture?

1 13503

Explain MySQL locks?

1 5127

Explain multi-version concurrency control in MySQL?

2 9638

What are MySQL transactions?

2 5298

What is ACID?

2 5811

Which storage engines support transactions in MySQL?

2 7515

How do you convert to a different table type?

1 3982

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

2 5040

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

Aufait, CSS, Wipro,

4 14513

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is difference between mysql and mysqli?

863

How do I create a schema in mysql?

819

Why MySQL is used?

966

Is mysql free download?

807

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

881

Can mysql scale horizontally?

925

Is mysql a distributed database?

894

What is mysql vs sql?

923

What is difference between mysqli and pdo?

869

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

2178

How do you say mysql?

822

What is mysql server?

996

Why we use mysqli instead of mysql?

1006

What is new mysqli?

860

Is mysql from oracle?

916

For More Un-Answered { MySQL } Questions Click Here