MC	Which statement is CORRECT?	DASD stands for directly accumulative storage device.	incorrect	Search trees are a good alternative to B-trees and B+-trees because they allow for better maintenance.	incorrect	The performance gain of binary search trees over linear search becomes larger as the number of key values increases.	correct	An unbalanced B-tree allows for additional performance gain by reducing the height of the tree.	incorrect	
MC	Which statement is NOT CORRECT?	A search key can be used to retrieve all records of which a certain attribute type falls within a range	incorrect	A search key determines the criteria for retrieving records	incorrect	A search key needs to be a unique identifier of a record	correct	A search key can be composite, meaning that it can consist of a combination of values	incorrect	
MC	Which statement is CORRECT?	DASD stands for directly accumulative storage device.	incorrect	DASD stands for database appropriate storage device.	incorrect	A search key can be used to retrieve all records of which a certain attribute type falls within a range	correct	An unbalanced B-tree allows for additional performance gain by reducing the height of the tree.	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	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	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	Which of the following file organization methods is not a primary file organization method?	Sequential file organization	incorrect	Heap files	incorrect	Hash file organization	incorrect	Linked lists	correct	
MC	Which statement is NOT CORRECT?	A search key needs to be a unique identifier of a record	correct	A search key can be composite, meaning that it can consist of a combination of values	incorrect	A search key determines the criteria for retrieving records	incorrect	A search key can be used to retrieve all records of which a certain attribute type falls within a range	incorrect	
MC	When translating a logical data model into an internal data model, what should be taken into account?	The physical storage properties	incorrect	The types of operations that will be executed on the data	incorrect	The size of the database	incorrect	All of these aspects should be taken into account	correct	
MC	When can the relative location technique for record organization be problematic?	When there are a lot of relations	incorrect	When there are a large number of records	incorrect	When there are many missing values in records	correct	When there are many different data types	incorrect