MySQL Interview Questions
Questions Answers Views Company eMail

What are some good ideas regarding user security in MySQL?

2 4250

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9135

What does myisamchk do?

1 3753

Explain advantages of InnoDB over MyISAM?

1 7559

Explain advantages of MyISAM over InnoDB?

1 5811

What are HEAP tables in MySQL?

1 12156

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

1 8126

What are CSV tables?

1 5449

Explain federated tables?

Tech Mahindra,

3 7729

What is SERIAL data type in MySQL?

Aspire,

3 46197

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

2 11365

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

ABC,

2 5304

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

1 2933

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 4525

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 9009


Post New MySQL Questions

Un-Answered Questions { MySQL }

What storage engines are used in MySQL?

508


What is the limitation of mysql?

467


Explain the different types of constraints?

509


What are mysql functions?

484


What is “i_am_a_dump” flag in mysql?

549






How is mysql database stored?

527


What is the storage engine for mysql?

488


What is dblink?

478


What can I do with mysql?

496


What is the usage of regular expressions in mysql?

482


What is the hostname for mysql database?

459


How many queries can mysql handle?

491


List some comparisons operators used in mysql?

517


Difference between CHAR and VARCHAR?

576


How to delete a table.

505