| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How can increase the performance of MySQL select query? | Span-Systems | 1 |
| How many ways we can we find the current date using MySQL? | | 3 |
| how to find missing numbers between two order numbers;
and dates ? | | 1 |
| 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 |
| what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ? | Tesco | 4 |
| What does tee command do in MySQL? | | 1 |
| about foregine | | 2 |
| what if you really want to store the timestamp data, such
as the publication date of the article? | | 1 |
| suppose server is running Suddenly down . what can you do?
but i want do not down the server? | | 1 |
| How many tables will create when we create table, what are they? | | 2 |
| ru compare the 2 null values? | ACC | 1 |
| What is the difference between GROUP BY and ORDER BY in
Sql? | Renault-Nissan | 2 |
| How do you start and stop MySQL on Windows? | | 1 |
| Explain MySQL locks? | | 1 |
| What does myisamchk do? | | 1 |
| How can you do the fine tunning? | ACC | 2 |
| Explain Normalization concept? | Inuva | 1 |
| Explain advantages of MyISAM over InnoDB? | | 1 |
| How do you prevent MySQL from caching a query? | | 1 |
| What is maximum size of a database in MySQL? | V2-Solutions | 2 |
| |
| For more MySQL Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
