File organization and access methods MCQs

15
Score: 0
Attempted: 0/15
1. Which file organization method ensures that records are stored in a sequence based on a key field?



2. What is the primary purpose of an index in a database?



3. In which file organization method are records stored randomly on the disk?



4. Which of the following is a characteristic of hash file organization?



5. What type of index stores pointers to the actual data records in the database?



6. Which access method is used to retrieve records sequentially from a file?



7. In which file organization method are related records stored together in the same disk block?



8. Which type of index is created on non-primary key columns to speed up query performance?



9. What is the main advantage of using a clustered index?



10. In a B-tree index, what is the term for the lowest level where actual data records are stored?



11. Which file organization method uses a hash function to compute the address of the record?



12. What is the benefit of using a dense index over a sparse index?



13. Which file organization method is most efficient for range queries?



14. In the context of indexing, what does the term ‘fan-out’ refer to?



15. Which access method allows records to be read in any order without regard to their physical sequence?



More MCQs Of Database Systems

Related Posts:

Contents Copyrights Reserved By T4Tutorials