Sql Interview QUESTIONS AND ANSWERS :: part3 : 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.Which SQL keyword is used to retrieve a maximum value ? |
MOST |
TOP |
MAX |
UPPER |
2.Which SQL function is used to count the number of rows in a SQL query ? |
COUNT() |
NUMBER() |
SUM() |
COUNT(*) |
3.In the following query how many rows will be updated? UPDATE person SET lname=’s’, Fname=’p’, WHERE person_id<10; /* person_id is a primary key */ |
0-9 |
1-6 |
No row |
None of these |
4.Which of the following SQL clauses is used to DELETE tuples from a database table ? |
DELETE |
REMOVE |
DROP |
CLEAR |
5.In the following query how many rows will be updated? UPDATE person SET lname=’s’, Fname = ’p’, WHERE person_id = 1; /* person_id is a primary key */ |
Single row |
Double row |
No row |
None of these |
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