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 5040

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9778

What does myisamchk do?

1 4378

Explain advantages of InnoDB over MyISAM?

1 8166

Explain advantages of MyISAM over InnoDB?

1 6411

What are HEAP tables in MySQL?

1 12866

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

1 8916

What are CSV tables?

1 6136

Explain federated tables?

Tech Mahindra,

3 8951

What is SERIAL data type in MySQL?

Aspire,

3 47905

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

2 12257

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

ABC,

2 6163

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

1 3528

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 5211

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 10160

Post New MySQL Questions

Un-Answered Questions { MySQL }

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1078

What is difference between schema and table?

864

How do stored procedures work?

951

What is mysqli_connect_error ()?

970

What is difference between inner vs self vs cross?

907

Does mysql scale well?

836

What is the default password for mysql?

844

What are the non-standard sql commands supported by 'mysql'?

920

using primary can we relate two table, with out foreign key?

2657

Explain the difference between mysql and mysql interfaces in php?

1007

What are the objects can be created using CREATE statement?

943

What data structure does mysql use?

944

How to enter boolean values in sql statements?

1064

How can I create table in mysql?

955

How to convert dates to character strings?

996

For More Un-Answered { MySQL } Questions Click Here