MC	Which statement is NOT CORRECT?	In a file-based approach, every application had its own query and access procedures, even if they wanted to access the same data.	incorrect	SQL is a database language that allows different applications to access different subsets of the data necessary for each application.	incorrect	SQL is a database language that focusses on how to access and retrieve the data.	correct	SQL is a database language to manage DBMSs without having to write a substantial amount of programming code.	incorrect	
MC	Which statement is NOT CORRECT?	ACID stands for Availability, Consistency, Isolation and Durability.	correct	A file-based approach to data management will easily lead to inconsistent data.	incorrect	A file-based approach to data management causes duplicate information, which leads to a waste of storage resources.	incorrect	SQL is a database language that allows different applications to access different subsets of the data necessary for each application.	incorrect	
MC	Which statement is NOT CORRECT?	The file approach to data management causes the same information to be stored separately for different applications.	incorrect	Views can be defined for a particular application or a user group. This facilitates control of data access and security.	incorrect	A database state contains the description of the database data and is stored in the catalog.	correct	A database approach to data management uses the available storage in a more efficient manner.	incorrect	
MC	Consider this rule: "An employee of a department can never earn more than the manager of the department." This is an example of a:	Semantical integrity rule	correct	Syntactical integrity rule	incorrect	
MC	Which statement is CORRECT?	A database state contains the description of the database data and is stored in the catalog.	incorrect	Changes in any of the layers in the three-layer architecture should minimally impact the other layers.	correct	ACID stands for Availability, Consistency, Isolation and Durability.	incorrect	It is more cumbersome to query a database system than a file-based system.	incorrect	
MC	Statement A: DDL is the language used to define the logical data model, but no other data models. <br><br> Statement B: SQL is a DML language to retrieve, insert, delete and modify data. It is stored in the catalog. <br><br>Which sentence(s) is/are right?	Only B	incorrect	Neither A or B	correct	Only A	incorrect	A and B	incorrect	
MC	Statement A: DDL is the language used to define the logical data model, but no other data models. <br><br> Statement B: SQL is a DML language to retrieve, insert, delete and modify data. It is stored in the catalog. <br><br>Which sentence(s) is/are right?	Only B	incorrect	A and B	incorrect	Only A	incorrect	Neither A or B	correct	
MC	Statement A: The middle layer of the three-layer architecture consists of both the conceptual data model and the logical data model. The logical data model is physically implemented in the internal layer. <br><br> Statement B: The top level of the three-layer architecture is the external layer. Views for one or more applications always offer a window on the complete logical model.<br><br>Which sentence(s) is/are right?	Neither A or B is right	incorrect	Only sentence A is right	correct	Sentence A and B are right	incorrect	Only sentence B is right	incorrect	
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?	Neither A or B	incorrect	Only B	incorrect	A and B	correct	Only A	incorrect	
MC	Which statement is NOT CORRECT?	Changes in any of the layers in the three-layer architecture should minimally impact the other layers.	incorrect	Examples of implementations of logical data models are hierarchical, CODASYL, relational or object-oriented models.	incorrect	In a database approach, the data definitions or metadata are stored in the applications accessing the data.	correct	A file-based approach to data management will easily lead to inconsistent data.	incorrect