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 5384

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

1 5493

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

2 7012

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 72721

Explain the difference between BOOL, TINYINT and BIT?

1 5752

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

3825

Explain MySQL architecture?

1 13206

Explain MySQL locks?

1 4867

Explain multi-version concurrency control in MySQL?

2 9147

What are MySQL transactions?

2 4913

What is ACID?

2 5434

Which storage engines support transactions in MySQL?

2 7108

How do you convert to a different table type?

1 3693

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

2 4619

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

Aufait, CSS, Wipro,

4 13735

Post New MySQL Questions

Un-Answered Questions { MySQL }

Is mysql a programming language?

650

Write a query to fetch duplicate records from a table using mysql?

702

How many queries can mysql handle?

715

How do I show all mysql databases?

708

What is full form of xampp?

803

What is the datatype of image?

710

How to use triggers to track changes in mysql?

666

How to get nth highest salary from table in a mysql?

706

What do you need to connect php to mysql?

715

How do I create a database in mysql workbench?

629

What is maximum table size in mysql?

689

How do I kill a mysql query?

638

What is federated tables in mysql?

674

How many rows can a mysql table hold?

686

How do you rename a procedure in mysql?

694

For More Un-Answered { MySQL } Questions Click Here