| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are HEAP tables in MySQL? | | 1 |
| Which storage engines support transactions in MySQL? | | 1 |
| What is maximum size of a database in MySQL? | V2-Solutions | 9 |
| The table tbl_sites contains the following data:
-----------------------------------------------------
Userid sitename country
------------------------------------------------------
1 sureshbabu indian
2 PHPprogrammer andhra
3 PHP.net usa
4 PHPtalk.com germany
5 MySQL.com usa
6 sureshbabu canada
7 PHPbuddy.com pakistan
8. PHPtalk.com austria
9. PHPfreaks.com sourthafrica
10. PHPsupport.net russia
11. sureshbabu australia
12. sureshbabu nepal
13. PHPtalk.com italy
Write a select query that will displayed the duplicated
site name and how many times it is duplicated? | Afixi | 3 |
| How can you do the fine tunning? | ACC | 3 |
| SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
| HCL | 3 |
| what is the Dynamic management views? where can you use? | ACC | 1 |
| What are the differences between MySQL_fetch_array(),
MySQL_fetch_object(), MySQL_fetch_row()? | | 2 |
| What does tee command do in MySQL? | | 1 |
| suppose server is running Suddenly down . what can you do?
but i want do not down the server? | | 3 |
| if we want to load data from a text file into a mysql table,
but the columns in table are 1st: code(int) and 2nd:
city(varchar), but in text file the format is 1st cityname
and then code separeted by delimeters. how to load? | | 2 |
| What are the advantages of stored procedures, triggers,
indexes? | | 2 |
| How to find out the second largest element from mysql table | | 11 |
| What happens if a table has one column defined as TIMESTAMP? | | 1 |
| Ondelete clause is specified with
a.)Drop table
b.)Delete command
c.)Create table
d.)Select command | AMDOC | 4 |
| 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 |
| Explain Normalization concept? | Inuva | 1 |
| What does myisamchk do? | | 1 |
| Use mysqldump to create a copy of the database? | | 1 |
| what is collation?
how many types of installations in sql server? | | 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
