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
4 7205Post New Covansys Interview Questions
What are the three domains of life?
What is the difference between PS & metering CT (5p20,0.5 etc.)? Why in PS class CT only Vk is given ? Is PS class CT is more accurate than metering CT?
What is database deadlock ? How can we avoid them?
Tell me briefly about sap.
Which one would you recommend for hbase table design approach – tall-narrow or flat wide?
How to assign Null value to Var?
Is laravel an mvc framework?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How one may guess the direction from which the distribution line is incoming if there is no pole plate on poles?
What is ambagious result in C? explain with an example.
How do you configure SharePoint to work with CRM 2011?
Which is the best approach for creating thread ?
How are structure passing and returning implemented?
What is named native query in hibernate?
How to read, write and delete session in cakephp?