| Other MySQL Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| Explain MySQL architecture? |
| 1 |
| Use mysqldump to create a copy of the database? |
| 2 |
| What are CSV tables? |
| 1 |
| How many tables will create when we create table, what are they? |
| 5 |
| SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
|
HCL | 5 |
| What is the main different between Null and NOT Null.
Difference between Primary and Unique Key.
How to Check the database from which application is it
possibe. |
| 6 |
| maximum size of a database in mysql? |
| 2 |
| Explain advantages of MyISAM over InnoDB? |
| 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 is the difference between GROUP BY and ORDER BY in
Sql? |
Renault-Nissan | 12 |
| How do you control the max size of a HEAP table? |
| 1 |
| How can we find the number of rows in a table using MySQL? |
| 3 |
| |
| For more MySQL Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
