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: conceptual	incorrect	A: internal, B: logical	correct	A: conceptual, B: internal	incorrect	A: logical, B: internal	incorrect	
MC	Which statement is CORRECT?	The logical data model is implementation independent.	incorrect	The file-based approach uses metadata to define the data. These definitions are then stored in a catalog.	incorrect	The three KPIs of a DBMS are response time, throughput rate and space utilization.	correct	SQL is a database language that focusses on how to access and retrieve the data.	incorrect	
MC	Which statement is NOT CORRECT?	Examples of implementations of logical data models are hierarchical, CODASYL, relational or object-oriented models.	incorrect	In a conceptual data model, the data requirements from the business should be captured and modeled.	incorrect	A conceptual data model is implementation dependent.	correct	A logical data model translates the conceptual data model to a specific implementation environment.	incorrect	
MC	Which statement is NOT 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, the data definitions or metadata are stored in the applications accessing the data.	correct	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	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	Complete this sentence: In the three-layer architecture, between the external layer and the conceptual/logical layer, there is...	Physical data independence	incorrect	The internal layer	incorrect	No independence, they are basically the same thing	incorrect	Logical data independence	correct	
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: conceptual	incorrect	A: internal, B: logical	correct	A: conceptual, B: internal	incorrect	A: logical, B: internal	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	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	Neither A or B	correct	Only A	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?	A and B	incorrect	Only A	incorrect	Only B	incorrect	Neither A or B	correct