Exam2win > Programming > Sql Interview > part1

Sql Interview Questions and Answers

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

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