| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 collation?
how many types of installations in sql server? | | 2 |
| What are CSV tables? | | 1 |
| How do you start MySQL on Linux? | | 3 |
| what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage | ABC | 2 |
| Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
CURRENT_TIMESTAMP. | | 1 |
| what is the difrence between sql and pl/sql | Wipro | 16 |
| Explain the difference between MyISAM Static and MyISAM
Dynamic? | | 1 |
| 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 are the different table present in MYsql? | | 1 |
| Explain the difference between BOOL, TINYINT and BIT? | | 1 |
| what are the optimization techniques for
Query optimization
performance issues and
faster execution of queries | | 1 |
| in a master-master replication with two masters and
alternate slaves running on two systems.can i have a script
or any mysql command to know which one is right now acting
as master. | | 1 |
| What is SERIAL data type in MySQL? | | 2 |
| How do you index just the first four bytes of the column? | | 2 |
| How many tables will create when we create table, what are they? | | 2 |
| What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table? | | 1 |
| Which storage engines support transactions in MySQL? | | 1 |
| What is the difference between GROUP BY and ORDER BY in
Sql? | Renault-Nissan | 2 |
| What are the other commands to know the structure of table
using MySQL commands except explain command? | SigmaTree | 2 |
| |
| 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
