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 5184

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9886

What does myisamchk do?

1 4492

Explain advantages of InnoDB over MyISAM?

1 8280

Explain advantages of MyISAM over InnoDB?

1 6538

What are HEAP tables in MySQL?

1 12988

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

1 9001

What are CSV tables?

1 6239

Explain federated tables?

Tech Mahindra,

3 9137

What is SERIAL data type in MySQL?

Aspire,

3 48178

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

2 12409

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

ABC,

2 6307

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

1 3708

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 5334

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 10312

Post New MySQL Questions

Un-Answered Questions { MySQL }

What are the technical specifications of mysql?

1167

What is deterministic in mysql?

986

how to Return total number of rows.

1013

Does insert statement lock the table?

950

what is the procedure to configure the application of mysql?

1043

How to delete a table.

931

How many types of indexes are there in mysql?

915

What is mysqli_free_result?

904

How to create a new view in mysql?

926

What is a result set object?

961

List some comparisons operators used in mysql?

991

What is a select query?

864

What does mysqli_fetch_assoc do?

920

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

1127

Can a table have multiple primary keys?

908

For More Un-Answered { MySQL } Questions Click Here