| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the different table present in MYsql? | | 1 |
| 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 |
| How many tables will create when we create table, what are they? | | 2 |
| Explain federated tables? | | 2 |
| How do you prevent MySQL from caching a query? | | 1 |
| If we create a column with data type VARCHAR(3), what would
we expect to see in MySQL table? | | 1 |
| What is the difference between mysql_fetch_array and
mysql_fetch_object? | | 2 |
| what if you really want to store the timestamp data, such
as the publication date of the article? | | 1 |
| what are the optimization techniques for
Query optimization
performance issues and
faster execution of queries | | 1 |
| i made a table in sql server 2000 and in a column i want to
add image path of a picture present in my hardisk... so
using insert statement how will i insert the path of the
image in the table?? | WebTech | 1 |
| What are HEAP tables in MySQL? | | 1 |
| ru compare the 2 null values? | ACC | 1 |
| suppose server is running Suddenly down . what can you do?
but i want do not down the server? | | 1 |
| Explain MySQL architecture? | | 1 |
| Explain advantages of InnoDB over MyISAM? | | 1 |
| 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 |
| What is maximum size of a database in MySQL? | V2-Solutions | 2 |
| How to get full name of monthname ? | | 3 |
| How can we repair a MySQL table? | Infosys | 1 |
| How do you start and stop MySQL on Windows? | | 1 |
| |
| 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
