MC	Which statement is NOT CORRECT?	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	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	In which of these cases can we make use of delimiters to separate attributes?	The data is stored in mixed files	incorrect	Some attributes have data types that can have variable lengths as input	incorrect	Some attributes are multivalued	incorrect	In all of these cases	correct	
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 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 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	Which of the following file organization methods is not a primary file organization method?	Heap files	incorrect	Linked lists	correct	Hash file organization	incorrect	Sequential file organization	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	Entries of dense indexes always refer to a group of records.	incorrect	Sparse indexes are generally faster than dense indexes.	incorrect	Dense indexes are more complex to maintain than sparse indexes.	correct	
MC	Which of the following statements with regards to indexed sequential file organization is correct?	Entries of dense indexes always refer to a group of records.	incorrect	The search key of a sparse index is a unique key (i.e. a primary key or candidate key).	incorrect	Dense indexes are more complex to maintain than sparse indexes.	correct	Sparse indexes are generally faster than dense indexes.	incorrect	
MC	What does DASD stand for?	Directly accessible storage device	correct	Directly accumulative storage device	incorrect	Data accumulative storage device	incorrect	Database appropriate storage device	incorrect	
MC	How is a row/tuple translated into an internal data model?	Data set	incorrect	Data item	incorrect	Stored record	correct	Physical storage structure	incorrect