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