MC	Which statement is CORRECT?	The internal data model represents the data's physical storage details.	correct	To communicate with the business user, mainly the logical data model is used.	incorrect	The logical data model is implementation independent.	incorrect	A database state contains the description of the database data and is stored in the catalog.	incorrect	
MC	Which statement is NOT CORRECT?	Isolation ensures that the effect of concurrent transactions should be the same as if they had been executed in isolation.	incorrect	Consistency assures that the database is consistent at all times.	incorrect	Durability means that effects of each successful transaction can be made permanent.	incorrect	ACID stands for Availability, Consistency, Isolation and Durability.	correct	
MC	Which statement is NOT CORRECT?	A database approach to data management uses the available storage in a more efficient manner.	incorrect	Space utilization is the space utilized to store raw data and metadata.	incorrect	The throughput rate is the number of transactions a DBMS can process per unit of time.	incorrect	In a database approach, the data definitions or metadata are stored in the applications accessing the data.	correct	
MC	Which statement is NOT CORRECT?	The internal data model is situated in the internal layer.	incorrect	The external layer of a database contains the logical and conceptual data model.	correct	Views can be defined for a particular application or a user group. This facilitates control of data access and security.	incorrect	Changes in any of the layers in the three-layer architecture should minimally impact the other layers.	incorrect	
MC	Which statement is NOT CORRECT?	Isolation ensures that the effect of concurrent transactions should be the same as if they had been executed in isolation.	incorrect	Consistency assures that the database is consistent at all times.	incorrect	Durability means that effects of each successful transaction can be made permanent.	incorrect	ACID stands for Availability, Consistency, Isolation and Durability.	correct	
MC	Which statement is NOT CORRECT?	A logical data model translates the conceptual data model to a specific implementation environment.	incorrect	In a conceptual data model, the data requirements from the business should be captured and modeled.	incorrect	Examples of implementations of logical data models are hierarchical, CODASYL, relational or object-oriented models.	incorrect	A conceptual data model is implementation dependent.	correct	
MC	Statement A: Physical data independence implies that neither the applications, nor the views or logical data models must be changed when changes are made to the data storage specifications in the internal data model. <br><br> Statement B: Logical data independence implies that software applications are minimally affected by changes in the conceptual or logical data model. <br><br>Which sentence(s) is/are right?	Only A	incorrect	Neither A or B	incorrect	Only B	incorrect	A and B	correct	
MC	Which statement is CORRECT?	To communicate with the business user, mainly the logical data model is used.	incorrect	A database state contains the description of the database data and is stored in the catalog.	incorrect	The logical data model is implementation independent.	incorrect	The internal data model represents the data's physical storage details.	correct	
MC	Which statement is NOT CORRECT?	In a file approach to data management, different applications could be using older and newer versions of the same data.	incorrect	In a file approach to data management, the data definitions are included in each application separately.	incorrect	The file approach to data management causes the same information to be stored separately for different applications.	incorrect	In a file approach to data management, a change in the structure of a data file is easily handled because each application has its own data files.	correct	
MC	Complete this sentence: In the three-layer architecture, between the external layer and the conceptual/logical layer, there is...	Logical data independence	correct	Physical data independence	incorrect	The internal layer	incorrect	No independence, they are basically the same thing	incorrect