| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is collation?
how many types of installations in sql server? | | 2 |
| How many services is running in sql server? | ACC | 3 |
| What are HEAP tables in MySQL? | | 1 |
| How can you do the fine tunning? | ACC | 2 |
| suppose server is running Suddenly down . what can you do?
but i want do not down the server? | | 1 |
| 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 |
| What is the difference between mysql_connect() and
mysql_pconnect()? | | 3 |
| how we can use more then one primary key in Single Table | Systematix | 7 |
| How can we change the name of a column of a table? | | 2 |
| How do you start and stop MySQL on Windows? | | 1 |
| How many ways we can we find the current date using MySQL? | | 3 |
| If you specify the data type as DECIMAL (5,2), what?s the
range of values that can go in this table? | | 1 |
| Explain the difference between mysql and mysqli interfaces
in PHP? | | 3 |
| 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 many tables will create when we create table, what are
they? | | 2 |
| What are the other commands to know the structure of table
using MySQL commands except explain command? | SigmaTree | 2 |
| SQL:
1. Write a queryto retrieve the author who was
published a book at the youngest age?
2. write a query to retrieve the no. of books
published a each year in various languages?
3. write a query to retrieve no. of books published by
them only those authors who have published more than 1 book?
4. write a query to retrieve who has not published any
books during the year 2006?
5. write a query to retrieve the authors who has
published any books during the birth date write this query
in 2 ways 1)joins 2)sub query
6. write a query to retrieve all the books which was
published during jan 2007 & title containing India or
published in the language hindi?
1. table name is liberary managemnt and two column is
there one is authors and another one is books .
2.four fields will comes under authours like nationality,
birthdate ,first-language,second-language
3.four fields will comes under books like
authour,title ,language,publish date to write query using
this details | Covansys | 3 |
| How can we know the number of days between two given dates
using MySQL? | Webworks | 2 |
| How many values can the SET function of MySQL take? | Creative-Informatics | 1 |
| what is JOIN? Give example & types of join? | iMedia | 7 |
| |
| 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
