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 5905

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

1 5869

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

2 7507

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 75093

Explain the difference between BOOL, TINYINT and BIT?

1 6176

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

4091

Explain MySQL architecture?

1 13585

Explain MySQL locks?

1 5220

Explain multi-version concurrency control in MySQL?

2 9774

What are MySQL transactions?

2 5425

What is ACID?

2 5917

Which storage engines support transactions in MySQL?

2 7648

How do you convert to a different table type?

1 4072

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

2 5156

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

Aufait, CSS, Wipro,

4 14685

Post New MySQL Questions

Un-Answered Questions { MySQL }

Is mysql still popular?

916

What ascii 31?

942

How do I start mysql from command line?

998

How can I see connections in mysql?

914

Is microsoft sql same as mysql?

979

How do I run mysql?

993

What is mysql used for?

955

Does mysql support nosql?

907

How do you kill a long running query in mysql?

883

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

3189

How would you get the current date in mysql?

1093

How many groups of data types?

973

How to get a list of all tables in a database?

1045

What is localhost in mysql?

994

What is the difference between procedure and function in mysql?

1013

For More Un-Answered { MySQL } Questions Click Here