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

MySQL Interview Questions

Questions Answers Views Company eMail

How do you prevent MySQL from caching a query?

1 4789

What?s the difference between query_cache_type 1 and 2?

1 7479

How can we repair a MySQL table?

Infosys,

2 7315

What are the advantages of stored procedures, triggers, indexes?

5 33579

What is the maximum length of a table name, database name, and fieldname in MySQL?

Accenture, Pioneer, TISL,

3 31010

How many values can the SET function of MySQL take?

Creative Informatics,

2 9982

What are the other commands to know the structure of table using MySQL commands except explain command?

SigmaTree,

2 7483

How many tables will create when we create table, what are they?

2 5135

What is maximum size of a database in MySQL?

Bastioncoup, CIS, NM, V2 Solutions, Wipro,

13 43154

Give the syntax of Grant and Revoke commands?

1 9204

Explain Normalization concept?

Inuva,

2 10324

How can we find the number of rows in a table using MySQL?

3 8278

How many ways we can we find the current date using MySQL?

5 12806

How can increase the performance of MySQL select query?

RV Technologies, Span Systems,

3 11963

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 4835

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is memory table?

911

How can you find out the version of the installed mysql?

1324

What are the two types of queries?

971

How to make a copy values from one column to another in mysql?

1038

What is localhost in mysql?

1009

can you tell how can you display the maximum salary in sql? : Mysql dba

868

Is mysql a database?

956

What is the phantom problem?

1010

What is striped backup

2247

How to shut down the server with 'mysqladmin'?

967

How would you enter characters as hex numbers?

950

How to use in conditions?

1014

How can we convert between Unix & MySQL timestamps?

968

How do I exit mysql?

925

How do you name a table?

901

For More Un-Answered { MySQL } Questions Click Here