| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| A select query over a large table runs very slow because of
the growing number of entries in that table. What different
measures could be taken to improve speed? | | 3 |
| How to get full name of monthname ? | | 3 |
| What is ACID? | | 2 |
| How can we repair a MySQL table? | Infosys | 2 |
| Explain advantages of MyISAM over InnoDB? | | 1 |
| what is the difrence between sql and pl/sql | Wipro | 18 |
| What are HEAP tables in MySQL? | | 1 |
| What?s the difference between PRIMARY KEY and UNIQUE in
MyISAM? | CSS | 2 |
| how to repair a table in mysql? | | 1 |
| what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage | ABC | 3 |
| How do you change a password for an existing user via
mysqladmin? | | 1 |
| How many ways we can we find the current date using MySQL? | | 1 |
| How do you start MySQL on Linux? | | 3 |
| what is collation?
how many types of installations in sql server? | | 3 |
| Explain Normalization concept? | Inuva | 1 |
| How would you backup and restore a big MySQL database? What
are the advantages of the approach which you have taken
over the others? | | 2 |
| How can we find the number of rows in a table using MySQL? | | 1 |
| SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
| HCL | 3 |
| How do you control the max size of a HEAP table? | | 1 |
| How can we know the number of days between two given dates
using MySQL? | Webworks | 2 |
| |
| For more MySQL Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
