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 5163

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9864

What does myisamchk do?

1 4477

Explain advantages of InnoDB over MyISAM?

1 8266

Explain advantages of MyISAM over InnoDB?

1 6524

What are HEAP tables in MySQL?

1 12973

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

1 8994

What are CSV tables?

1 6214

Explain federated tables?

Tech Mahindra,

3 9111

What is SERIAL data type in MySQL?

Aspire,

3 48127

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

2 12386

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

ABC,

2 6267

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

1 3683

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 5301

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 10283

Post New MySQL Questions

Un-Answered Questions { MySQL }

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

1001

Explain % and _ inside like statement?

1005

What is difference between mysql mysqli and pdo?

931

Is mysql easy to learn?

940

What are numeric data types?

979

How to control the max size of a heap table?

993

How do I find users in mysql?

1096

How do I delete a mysql user?

842

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

958

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

1006

how you will Create a database on the mysql server with unix shell.

1032

What is the difference between the primary and unique key in mysql?

982

What are the advantages of mysql in comparison to oracle?

1023

What is foreign key in mysql?

1028

1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2494

For More Un-Answered { MySQL } Questions Click Here