
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
- TNTET 2021 - Practice
- SSC CGL 2021 - Practice
- TNPSC Group 2A 2021 - Practice
- IIT JEE
- IIT JEE Q&A
- TNPSC Answer Keys
- TNPSC Group 2 Syllabus
-
TNPSC Q&A

- Online Tests - TNPSC
- Online Tests - GK
- IBPS 2020-2021
- Online Tests - Bank
- Online Tests - RRB NTPC
- Online Tests - UGC NET
- Online Tests - TANCET
- Online Aptitude Test
-
Engineering

-
Programming

-
Basic Science

-
Quiz

- Plus Two Question Papers
- SSLC Question Bank
-
Aptitude Tests

-
Logical Reasoning

-
General Knowledge-Hindi

-
Indian History MCQ

-
Indian Geography MCQ

-
Indian Civics MCQ

-
Indian Economics MCQ

-
CTET Biology MCQ

-
CTET Chemistry MCQ

-
CTET Physics Solved MCQ

-
Arithmetic Tests

- Press Release
- FAQ
- Coaching Centres
- TNPSC Group 1 Syllabus
-
TNPSC Group IV Syllabus

- TRB 2017 in English PDF

- TRB 2017 in Tamil PDF

- TET
- TNTET
