MySQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MySQL Interview Questions

Questions Answers Views Company eMail

What are some good ideas regarding user security in MySQL?

2 5176

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9876

What does myisamchk do?

1 4483

Explain advantages of InnoDB over MyISAM?

1 8273

Explain advantages of MyISAM over InnoDB?

1 6530

What are HEAP tables in MySQL?

1 12983

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

1 8997

What are CSV tables?

1 6229

Explain federated tables?

Tech Mahindra,

3 9126

What is SERIAL data type in MySQL?

Aspire,

3 48156

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

2 12395

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

ABC,

2 6288

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

1 3697

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 5319

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 10297

Post New MySQL Questions

Un-Answered Questions { MySQL }

Where is mysql used?

995

Is oracle mysql free?

884

Where MyISAM table will be stored and also give their formats of storage?

1063

What is the purpose of using a heap table?

1118

What is processlist in mysql?

1002

How to use regular expression in pattern match conditions?

952

What is mysqladmin flush hosts?

950

Does facebook still use mysql?

932

What is 'mysqlimport'?

935

How to delete a column and add a new column to database

944

What is bdb (berkeleydb)?

941

What mysql -u john -p command does?

972

What is data types in mysql?

922

I want to start and stop mysql on windows? How do I do that?

1062

What is root password?

911

For More Un-Answered { MySQL } Questions Click Here