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 5798

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

1 5797

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

2 7418

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 74646

Explain the difference between BOOL, TINYINT and BIT?

1 6102

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

4041

Explain MySQL architecture?

1 13512

Explain MySQL locks?

1 5137

Explain multi-version concurrency control in MySQL?

2 9653

What are MySQL transactions?

2 5320

What is ACID?

2 5828

Which storage engines support transactions in MySQL?

2 7541

How do you convert to a different table type?

1 3994

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

2 5063

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

Aufait, CSS, Wipro,

4 14542

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is 'mysqlimport'?

875

Why do we write stored procedures?

860

How to print message in mysql trigger?

1448

How to return query output in html format?

883

What is pdo mysql?

882

What is striped backup

2206

What are the differences between char and varchar?

1050

How to convert dates to character strings?

1006

How to drop an existing index in mysql?

1032

How many tables we can create in mysql database?

897

What is mysql and mysqli?

878

How many ways to get the current time?

923

How can I create a database in mysql?

812

Is mysql relational database?

841

How do you create a schema?

887

For More Un-Answered { MySQL } Questions Click Here