MySQL Interview Questions
Questions Answers Views Company eMail

What are some good ideas regarding user security in MySQL?

2 3284

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 8250

What does myisamchk do?

1 2894




Explain advantages of InnoDB over MyISAM?

1 6730

Explain advantages of MyISAM over InnoDB?

1 4928

What are HEAP tables in MySQL?

1 11077

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

1 6977

What are CSV tables?

1 4652




Explain federated tables?

Tech Mahindra,

3 6323

What is SERIAL data type in MySQL?

Aspire,

3 42164

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

2 10040

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

ABC,

2 4320

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

1 2218

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 3728

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 7638


Post New MySQL Questions






Un-Answered Questions { MySQL }

What are the functions used to encrypt and decrypt the data present in mysql?

64


How to shut down the server with 'mysqladmin'?

84


What is mysql procedure?

29


How can I see mysql database?

41


What is the purpose of using a heap table?

67






What is pdo mysql?

38


What is a left join mysql?

29


what is a cursor? : Mysql dba

69


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

1950


How to get current MySQL version?

97


How do I install and use mysql?

43


Does insert statement lock the table?

44


What is clob in mysql

38


How set mysql root password?

42


How you will show all data from a table.

69