MySQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MySQL Interview Questions

Questions Answers Views Company eMail

What are the different table present in MYsql?

3 11902

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 12210

How to set the time zone for MySQL to particular country time?

2724

What is the difference between mysql_connect() and mysql_pconnect()?

TCS,

7 25463

How can we store binary data in mysql?

HP,

2 6290

How can you get your MySQL root password, if you lost it?

PCS,

1 3097

How do you start and stop MySQL on Windows?

3 5974

How do you start MySQL on Linux?

3 5516

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 32741

What?s the default port for MySQL Server?

Yahoo,

4 7875

What does tee command do in MySQL?

1 8014

Can you save your connection settings to a conf file?

1 3897

How do you change a password for an existing user via mysqladmin?

2 6617

Use mysqldump to create a copy of the database?

2 5017

Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?

TCS,

1 4324

Post New MySQL Questions

Un-Answered Questions { MySQL }

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

573

Define REGEXP?

642

Can we store images in mysql database?

482

How do I free up space in mysql?

487

change column name and make a unique column so we get no dupes.

500

What is the difference between float and double?

587

How can an index be declared in mysql?

462

What is sharding in mysql?

509

Is mongodb faster than mysql?

503

What is a deterministic function?

595

How do you determine the location of mysql data directory?

489

How can I connect mysql database?

476

What is mysql url?

475

How does mysql store data?

521

What is mysql routine?

468

For More Un-Answered { MySQL } Questions Click Here