Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Covansys MySQL Interview Questions
Questions Answers Views Company eMail

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 6819

Post New Covansys MySQL Interview Questions




Un-Answered Questions

What is load-on-startup in servlet?

559


How do I open a template?

312


How to configure clear route cache in laravel?

396


Define the key challenges faced during software testing?

558


Where is the installation directory?

516






What is meant by union and union all?

551


Define a validation rule?

194


How long does it take to build a professional website?

107


You are a project manager for an engineering company. Your company won the bid to add ramp-metering lights to several on-ramps along a stretch of highway at the south end of the city. You subcontracted a portion of the project to another company. The subcontractor's work involves digging the holes and setting the lamp poles in concrete. The subcontractor's performance is not meeting the contract requirements, because the poles are not buried to the correct depth. Which of the following is true? A. You are in the Quality Assurance process and have performed a quality audit to assure correctness of work. B. You are in the Scope Verification process and have performed a quality audit to assure correctness of work. C. You are in the Contract Administration process and have completed a contract audit to assure the subcontractor's performance meets the contract requirements. D. You are in the Performance Reporting process and have completed a performance review of the contractor's work.

691


What are the four distinct types of memory in 8051?

1197


Which language is used for desktop application?

457


What is perl push array function?

517


What is hooks and types of hooks in wordpress?

125


How will you set the Dependency in the Quality center? Say if you will fail a test case and two or more test cases are dependent on that particular test case. In this case how will you handle in failing the test case.

2208


What is AOT Compilation?

479