| Other MySQL Interview Questions |
|| Asked @
|What is the difference between a Table and a View?
|What is the difference between CHAR and VARCHAR data types?
|Explain Normalization concept?
|what is the size of date datatype in sql?
|What does myisamchk do?
|How many tables will create when we create table, what are they?
|What is the main different between Null and NOT Null.
Difference between Primary and Unique Key.
How to Check the database from which application is it
|Is SET Command is SQL Statement..?
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,
3.four fields will comes under books like
authour,title ,language,publish date to write query using
|How do you convert to a different table type?
|how to find missing numbers between two order numbers;
and dates ?
|What?s the difference between query_cache_type 1 and 2?
|For more MySQL Interview Questions Click Here |