Software Programming : Database Management QUESTIONS AND ANSWERS :: part13 : 1 to 5
Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :
1.Which of the following best describes the internal level of the ANSI/SPARC three level architecture? |
| The internal level is concerned with the layout of records and their locations within disk blocks |
| The internal level is concerned with the data as seen by individuals internal to the enterprise |
| The internal level is concerned with the users� view of the data |
| The internal level is concerned with the how stored fields are represented and which indices exist |
| The internal level provides a conceptual view of the data structure. |
2.The unit of storage that can store one are more records in a hash file organization are |
| Buckets |
| Disk pages |
| Blocks |
| Nodes |
| Baskets. |
3.In the ANSI/SPARC three level database model, the external view is best described by which of the following options? |
| It is the link between users and the storage structures |
| It is dependent on the underlying DBMS product used (e.g. Oracle, DBASE) |
| It is the place where the users interface to the DBMS |
| It is not part of the model |
| It is the place where the storage structures link to the database. |
4.The file organization which allows us to read records that would satisfy the join condition by using one block read is |
| Heap file organization |
| Sequential file organization |
| Clustering file organization |
| Hash file organization |
| Index file organization. |
5.Which of the following is true with respect to the B+ tree index method? |
| Records are physically stored in primary key order |
| B+ trees use a hashing algorithm |
| The index tree may become unbalanced as a result of updates |
| Only the primary key field may have a B+ tree index |
| Records are physically stored in secondary key order. |
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
