MC	Complete the following sentence, choosing the right words on place <b>A</b> and <b>B</b>.<br><br>A ...<b>A</b>... data model is the mapping of a ...<b>B</b>... data model to a model that describes which data is stored where and in what format.	A: logical, B: internal	incorrect	A: internal, B: logical	correct	A: conceptual, B: internal	incorrect	A: logical, B: conceptual	incorrect	
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?	Only sentence A is right	correct	Only sentence B is right	incorrect	Sentence A and B are right	incorrect	Neither A or B is right	incorrect	
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?	Only sentence A is right	correct	Sentence A and B are right	incorrect	Only sentence B is right	incorrect	Neither A or B is right	incorrect	
MC	Which statement is CORRECT?	SQL is a database language to manage DBMSs without having to write a substantial amount of programming code.	correct	The maintenance of a file-based system is much easier than the maintenance of a database system.	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.	incorrect	The database is stored in the catalog.	incorrect	
MC	Which statement is NOT CORRECT?	In a database approach, the data definitions or metadata are stored in the applications accessing the data.	correct	In a database approach, applications don't have their own files, but all applications access the same version of the data by interfacing with the DBMS.	incorrect	In a database approach, maintenance of data and metadata is easier.	incorrect	In a database approach, there is typically less storage needed compared to the file approach.	incorrect	
MC	Which statement is NOT CORRECT?	The database state specifies the various data items, their characteristiscs and relationships and is specified during the database design.	correct	In a database approach, there is typically less storage needed compared to the file approach.	incorrect	A file-based approach to data management incurs a strong dependency between the applications and the data	incorrect	In a file-based approach, every application had its own query and access procedures, even if they wanted to access the same data.	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	The database is stored in the catalog.	correct	Views can be defined for a particular application or a user group. This facilitates control of data access and security.	incorrect	A file-based approach to data management incurs a strong dependency between the applications and the data	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?	Only A	incorrect	Only B	incorrect	A and B	correct	Neither A or B	incorrect	
MC	Which statement is NOT CORRECT?	In a database approach, there is typically less storage needed compared to the file approach.	incorrect	In a database approach, applications don't have their own files, but all applications access the same version of the data by interfacing with the DBMS.	incorrect	In a database approach, maintenance of data and metadata is easier.	incorrect	In a database approach, the data definitions or metadata are stored in the applications accessing the data.	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?	Only sentence A is right	correct	Only sentence B is right	incorrect	Neither A or B is right	incorrect	Sentence A and B are right	incorrect