MySQL Interview Questions
Questions Answers Views Company eMail

What are some good ideas regarding user security in MySQL?

2 4276

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9149

What does myisamchk do?

1 3771

Explain advantages of InnoDB over MyISAM?

1 7573

Explain advantages of MyISAM over InnoDB?

1 5822

What are HEAP tables in MySQL?

1 12171

How do you control the max size of a HEAP table?

1 8151

What are CSV tables?

1 5466

Explain federated tables?

Tech Mahindra,

3 7757

What is SERIAL data type in MySQL?

Aspire,

3 46251

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

2 11386

If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?

ABC,

2 5327

Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE CURRENT_TIMESTAMP.

1 2952

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 4539

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 9049


Post New MySQL Questions

Un-Answered Questions { MySQL }

How many TRIGGERS are allowed in MySql table?

584


What are the security alerts while using mysql?

575


Can varchar be primary key?

506


How to enter microseconds in sql statements?

520


What are the objects can be created using CREATE statement?

548






What does mysqli_fetch_assoc do?

486


What is a simple query?

470


How many rows can mysql hold?

471


List the different types of normalization?

528


What are procedures in mysql? Explain

526


What are the differences between binary and varbinary?

532


How many rows mysql can handle?

512


Where does mysql store data?

444


How to insert dynamic values in mysql using php?

537


How do you select a table?

485