MC Why is the blocking factor important to know? For calculating the seek time of a hard disk drive incorrect For achieving efficient access to records correct For determining the maximum size of the database incorrect For none of these reasons incorrect MC Which statement is CORRECT? An important application of tree data structures is when they provide a physical index structure to speed up retrieval of records. correct An inverted file defines an index over a unique, ordered search key of the data set. incorrect An advantage of one-way linked lists, where each record contains a pointer to its logical successor, is that not all records must be retrieved any longer, because frequently only part of the list needs to be processed. incorrect Secondary file organization methods make insertion and deletion of records a lot easier. incorrect MC Why is the blocking factor important to know? For calculating the seek time of a hard disk drive incorrect For achieving efficient access to records correct For determining the maximum size of the database incorrect For none of these reasons incorrect MC When can the relative location technique for record organization be problematic? When there are many missing values in records correct When there are a lot of relations incorrect When there are a large number of records incorrect When there are many different data types incorrect MC Which statement is CORRECT? An advantage of one-way linked lists, where each record contains a pointer to its logical successor, is that not all records must be retrieved any longer, because frequently only part of the list needs to be processed. incorrect An important application of tree data structures is when they provide a physical index structure to speed up retrieval of records. correct Secondary file organization methods make insertion and deletion of records a lot easier. incorrect An inverted file defines an index over a unique, ordered search key of the data set. incorrect MC What does DASD stand for? Data accumulative storage device incorrect Database appropriate storage device incorrect Directly accumulative storage device incorrect Directly accessible storage device correct MC Why is the blocking factor important to know? For calculating the seek time of a hard disk drive incorrect For achieving efficient access to records correct For determining the maximum size of the database incorrect For none of these reasons incorrect MC Which of the following statements with regards to indexed sequential file organization is correct? Dense indexes are more complex to maintain than sparse indexes. correct Sparse indexes are generally faster than dense indexes. incorrect The search key of a sparse index is a unique key (i.e. a primary key or candidate key). incorrect Entries of dense indexes always refer to a group of records. incorrect MC Which of the following statements with regards to indexed sequential file organization is correct? The search key of a sparse index is a unique key (i.e. a primary key or candidate key). incorrect Sparse indexes are generally faster than dense indexes. incorrect Entries of dense indexes always refer to a group of records. incorrect Dense indexes are more complex to maintain than sparse indexes. correct MC When can the relative location technique for record organization be problematic? When there are a large number of records incorrect When there are a lot of relations incorrect When there are many different data types incorrect When there are many missing values in records correct