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 5803

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

1 5804

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

2 7420

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 74663

Explain the difference between BOOL, TINYINT and BIT?

1 6106

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

4044

Explain MySQL architecture?

1 13519

Explain MySQL locks?

1 5142

Explain multi-version concurrency control in MySQL?

2 9664

What are MySQL transactions?

2 5323

What is ACID?

2 5831

Which storage engines support transactions in MySQL?

2 7546

How do you convert to a different table type?

1 3994

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

2 5070

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

Aufait, CSS, Wipro,

4 14546

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is data type for image in mysql?

832

What does mysql_query return?

968

How to change the database engine in mysql?

926

What is the full meaning of mysql?

923

In mysql, what is joins? Explain

920

What is difference between statement and preparedstatement?

930

Difference between CHAR and VARCHAR?

1031

What is a string in mysql?

858

What are the method you will follow while sql installing

2323

explain GROUPBY & HAVING clause with examples.

2235

Is oracle mysql free?

827

What is sqlyog?

987

How does mysql store data?

886

How do I setup mysql?

859

What are date and time data types in mysql?

968

For More Un-Answered { MySQL } Questions Click Here