Sql Interview Questions & Answers: part1



Sql Interview QUESTIONS AND ANSWERS :: part1 : 11 to 15

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

11.The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate. #2. The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

Where, from
From, select
Select, from
From, where

12.Select * from employee where salary>10000 and dept_id=101; Which of the following fields are displayed as output?

Salary, dept_id
Employee
Salary
All the field of employee relation

13.Select ID, name, dept name, salary * 1.1 where instructor; The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

Salary*1.1
ID
Where
Instructor

14._______________ joins are SQL server default

Outer
Inner
Equi
None of the Mentioned

More Sql Interview QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Failure defeats losers, failure inspires winners.-Robert T. Kiyosaki