Exam2win > Programming > Sql Interview > part2

Sql Interview Questions and Answers

1
2
3

Sql Interview QUESTIONS AND ANSWERS :: part2 : 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.Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.

Where, having

Having, where

Group by, having

Group by, where

12.Select emp_name from department where dept_name like ’ _____ Computer Science’; Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string ?

%

_

||

$

13.Which of the following is a aggregate function ?

Average

Sum

With

Minimum

14.Select instructor.* from instructor, teaches where instructor.ID= teaches.ID; This query does which of the following operation?

All attributes of instructor and teaches are selected

All attributes of instructor are selected on the given condition

All attributes of teaches are selected on given condition

Only the some attributes from instructed and teaches are selected

More Sql Interview QUESTIONS AND ANSWERS available in next pages

1
2
3

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

Opportunity is missed by most people because it is dressed in overalls and looks like work.- Thomas Edison

Related Online Test

Bank General Knowledge - Online Test 1
Bank General Knowledge - Online Test 3
Bank General Knowledge - Online Test 4
Bank General Knowledge - Online Test 5
Bank General Knowledge - Online Test 6
Bank Model question Paper - Online Test 1
Bank Numerical Ability - Online Test 1