
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
