Sql Interview Questions & Answers: part2



Sql Interview QUESTIONS AND ANSWERS :: part2 : 1 to 5

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

1.Select * from instructor order by salary ____, name ___; To display the salary from greater to smaller and name in ascending order which of the following options should be used ?

Ascending, Descending
Asc, Desc
Desc, Asc
Descending, Ascending

2.The EXISTS keyword will be true if:

Any row in the subquery meets the condition only.
All rows in the subquery fail the condition only.
Both of these two conditions are met.
Neither of these two conditions is met.

3.’_ _ _ ’ matches any string of ______ three characters. ’_ _ _ %’ matches any string of at ______ three characters.

Atleast, Exactly
Exactly, Atleast
Atleast, All
All , Exactly

4.Which is duplication of computer operations and routine backups to combat any unforeseen problems:

Concurrency
Deadlock
Backup
Recovery

5.In SQL the spaces at the end of the string are removed by _______ function .

Upper
String
Trim
Lower

More Sql Interview QUESTIONS AND ANSWERS available in next pages

    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