Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part6 : 6 to 10

Following SQL Multiple choice objective type questions and answers will help you in many software compnaies written examinations and inteview 2015 :

6.Select * from student join takes using (ID); The above query is equivalent to :

Select * from student inner join takes using (ID);

Select * from student outer join takes using (ID);

Select * from student left outer join takes using (ID);

All of the mentioned

7.Which clause is used to determine “which column to include in the query sets”?

SELECT

FROM

WHERE

ORDER BY

8.We can test for the nonexistence of tuples in a subquery by using the _____ construct.

Not exist

Not exists

Exists

Exist

9.Select __________ from instructor where dept name= ’Comp. Sci.’; Which of the following should be used to find the mean of the salary ?

Mean(salary)

Avg(salary)

Sum(salary)

Count(salary)

10.Select ________ dept_name from instructor; Here which of the following displays the unique values of the column ?

All

From

Distinct

Name

More Sql Interview QUESTIONS AND ANSWERS available in next pages

Health is the greatest gift, contentment is the greatest wealth -Buddha

The only place where success comes before work is in the dictionary.- Vidal Sassoon

Related Online Test