MySQL Interview Questions
Questions Answers Views Company eMail

What are some good ideas regarding user security in MySQL?

2 3173

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 8075

What does myisamchk do?

1 2809




Explain advantages of InnoDB over MyISAM?

1 6656

Explain advantages of MyISAM over InnoDB?

1 4817

What are HEAP tables in MySQL?

1 10905

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

1 6744

What are CSV tables?

1 4546




Explain federated tables?

Tech Mahindra,

3 6160

What is SERIAL data type in MySQL?

Aspire,

3 41429

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

2 9799

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

ABC,

2 4234

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

1 2145

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 3607

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 7516


Post New MySQL Questions






Un-Answered Questions { MySQL }

Explain the difference between mysql and mysql interfaces in php?

12


What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

12


How to create and drop view in mysql?

9


How to define numeric 9(3) in db2 table without decimal point??

1896


Which statement is used to delete a table in MySQL.

27






How to load data files into tables with 'mysqlimport'?

9


What are the technical specifications of mysql?

9


What is join in mysql? What are the different types of join?

8


How to convert character strings to dates?

11


How to rename an existing column in a table?

13


How to create table with same structure of student table in mysql?

7


how to Return total number of rows.

22


What is a trigger? How you can create a trigger in mysql?

9


Write a query to find duplicate rows in table?

5


How to determine the location of the data directory?

13