Question : In cluster file organization, the cluster key is used to:
Solution :
Correct Answer : Map and group related records from multiple tables
Description -
Question : Which of the following is a limitation of cluster file organization?
Solution :
Correct Answer : Poor performance when join condition changes
Description -
Question : What is the primary difference between indexed cluster and hash cluster?
Solution :
Correct Answer : Indexed cluster uses cluster key ordering, hash cluster uses hash function
Description -
Question : Which of the following scenarios is most suitable for using cluster file organization?
Solution :
Correct Answer : When frequent joins occur on the same key
Description -
Question : In cluster file organization, why are related tables stored together in the same data block?
Solution :
Correct Answer : To improve join performance by reducing I/O cost
Description -
Question : What happens to deleted records in ISAM?
Solution :
Correct Answer : Marked as deleted and may leave unused space
Description -
Question : Which combination of access methods is supported by ISAM?
Solution :
Correct Answer : Both sequential and random access
Description -
Question : Which of the following is a major limitation of ISAM?
Solution :
Correct Answer : Requires reconstruction after insertions
Description -
Question : In ISAM, where are newly inserted records stored if there is no space in the primary data file?
Solution :
Correct Answer : Overflow area
Description -
Question : Which of the following correctly describes the role of the index in ISAM?
Solution :
Correct Answer : Maps primary keys to memory addresses of records
Description -
Question : What happens when a leaf node overflows during insertion in a B+ tree?
Solution :
Correct Answer : Node is split and parent is updated
Description -
Question : Which of the following is a limitation of B+ file organization?
Solution :
Correct Answer : Inefficiency for static data
Description -
Question : Why is searching efficient in B+ file organization?
Solution :
Correct Answer : All records are at the same level and linked sequentially
Description -
Question : Which of the following best describes the role of internal nodes in a B+ tree?
Solution :
Correct Answer : Act as index nodes with pointers
Description -
Question : In B+ file organization, where are the actual records stored?
Solution :
Correct Answer : Leaf nodes
Description -