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 6040

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

1 5941

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

2 7623

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 75703

Explain the difference between BOOL, TINYINT and BIT?

1 6272

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

4154

Explain MySQL architecture?

1 13670

Explain MySQL locks?

1 5307

Explain multi-version concurrency control in MySQL?

2 9929

What are MySQL transactions?

2 5537

What is ACID?

2 6060

Which storage engines support transactions in MySQL?

2 7763

How do you convert to a different table type?

1 4176

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

2 5283

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

Aufait, CSS, Wipro,

4 14891

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is the purpose of using timestamp data type?

978

How do you say mysql?

961

What is the purpose of mysql database?

973

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

989

How do I restart mysql on windows?

1015

How do I automate a backup in mysql?

1048

How to convert character strings to numeric values?

1178

Can python connect to mysql?

1094

Can we write procedure in mysql?

991

How to calculate the difference between two dates?

1120

What are the differences between char and varchar?

1155

What are the differences between char and nchar?

1191

How to drop an existing table in mysql?

1063

How do I truncate all tables in mysql?

1042

What are the similarities between a function and a procedure?

964

For More Un-Answered { MySQL } Questions Click Here