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 75195

Explain the difference between BOOL, TINYINT and BIT?

1 6192

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

4097

Explain MySQL architecture?

1 13598

Explain MySQL locks?

1 5235

Explain multi-version concurrency control in MySQL?

2 9805

What are MySQL transactions?

2 5436

What is ACID?

2 5932

Which storage engines support transactions in MySQL?

2 7657

How do you convert to a different table type?

1 4082

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 14719

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is the difference between b-tree and hash indexes?

998

Why do we use preparedstatement?

916

How do I select a database in mysql workbench?

1013

Is mysqli deprecated?

958

What is data in mysql?

902

What does the file with the extension: frm, myd, and myi contain?

923

What is the data type for image?

1068

What is a tinyint?

958

What is the use of mysqli_query?

884

How many columns can a mysql table have?

906

What storage engines are used in MySQL?

1051

I want to find out all databases starting with ‘test’, I have access to?

1155

What is the data type for file in mysql?

986

How do I find users in mysql?

1103

What is the purpose of mysql database?

921

For More Un-Answered { MySQL } Questions Click Here