Software Programming : Database Management QUESTIONS AND ANSWERS :: part6 : 1 to 5
Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :
1.Out of the following activities, which is the one that normally performed by DBMS, without the interference of the DBA? |
| Integrity |
| Retention |
| Security |
| Granting the Privileges |
| Recovery. |
2.Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released? |
| Record controller |
| Exclusive lock |
| Authorization rule |
| Two phase lock |
| Three Phase lock. |
3.What does the following SQL statement do? Select * From Customer Where Cust_Type = "Best"; |
| Selects all the fields from the Customer table for each row with a customer labeled "best" |
| Selects the "*" field from the Customer table for each row with a customer labeled "best" |
| Selects fields with a "*" in them from the Customer table |
| Selects all the fields from the Customer table for each row with a customer labeled "*" |
| Counts all records and displays the value. |
4.A type of query that is placed within a WHERE or HAVING clause of another query is called |
| Master query |
| Sub query |
| Super query |
| Multi-query |
| Co-related query. |
5.Which of the following type of index is automatically created when we do not specify? |
| Bitmap |
| Balanced Tree Index |
| Binary Tree Index |
| Hashed |
| Sparse Index. |
More Database Management 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
