ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  MySQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
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
 Question Submitted By :: Sureshasall
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
Answer
# 1		 
select * from published book where min(age);
 
Is This Answer Correct ?    0 Yes 3 No
Nani
 
  Re: 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
Answer
# 2		 
select count(books),year(publish date)as 
Year_Published,language from library management a,books b 
where a.authour=b.authour group by Year_Published;
 
Is This Answer Correct ?    1 Yes 0 No
Vijay
 
 
 
  Re: 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
Answer
# 3		 
select count(a.books),year(b.publish date)as 
Year_Published,language from library management a,books b 
where a.authour=b.authour group by Year_Published;
 
Is This Answer Correct ?    0 Yes 0 No
Vijay
 

 
 
 
Other MySQL Interview Questions
 
  Question Asked @ Answers
 
What does tee command do in MySQL?  1
Explain MySQL architecture?  1
What is maximum size of a database in MySQL? V2-Solutions2
Explain multi-version concurrency control in MySQL?  2
What are CSV tables?  1
Explain the difference between MyISAM Static and MyISAM Dynamic?  1
What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?  2
What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?  2
How many tables will create when we create table, what are they?  2
How MySQL is different from SQL? HCL9
How can increase the performance of MySQL select query? Span-Systems1
What does myisamchk do?  1
what is collation? how many types of installations in sql server?  2
How can we store binary data in mysql? HP2
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?  1
How do you change a password for an existing user via mysqladmin?  1
suppose server is running Suddenly down . what can you do? but i want do not down the server?  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
about join  2
What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?  1
 
For more MySQL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com