Software Programming : Database Management QUESTIONS AND ANSWERS :: part6 : 6 to 10
Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :
6.Horizontal Fragmentation is |
Divide the data up by logical groups of records |
Divide the data up by logical groups of attributes |
Divide the data up by logical groups of entities |
Divide the data up by logical groups of files |
Divide the data up by logical frames. |
7.In an SQL statement, which of the following parts states the conditions for row selection? |
Select |
From |
Order By |
Group By |
Where. |
8.An index record appears for every search key value in the file is |
Secondary index |
Dense index |
Sparse index |
Multi level index |
B+ tree. |
9.The protocol that ensures conflict serializability is |
Time stamp ordering protocol |
Two phase locking protocol |
Concurrency protocol |
Tree protocol |
Layered Protocol. |
10.Which of the following questions is answered by the SQL statement? Select Count (Product_Description) from Product_T; |
How many products are in the Product Table? |
How many different product descriptions are in the Product Table? |
How many characters are in the field name "Product_Description"? |
How many different columns named "Product Description� is there in table Product_T? |
How many total records in a table? |
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