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: 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.

Statement B: Logical data independence implies that software applications are minimally affected by changes in the conceptual or logical data model.

Which sentence(s) is/are right? A and B correct Only B incorrect Neither A or B incorrect Only A 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.

Statement B: Logical data independence implies that software applications are minimally affected by changes in the conceptual or logical data model.

Which sentence(s) is/are right? Neither A or B incorrect A and B correct Only A incorrect Only B incorrect MC Which statement is CORRECT? The database state specifies the various data items, their characteristiscs and relationships and is specified during the database design. incorrect The database state changes when data is updated or removed. correct The database state represents the data in the database when the database is first created. incorrect The database is stored in the catalog. incorrect MC Complete this sentence: In the three-layer architecture, between the external layer and the conceptual/logical layer, there is... No independence, they are basically the same thing incorrect The internal layer incorrect Logical data independence correct Physical data independence 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 NOT CORRECT? SQL is a database language that focusses on how to access and retrieve the data. correct A file-based approach to data management incurs a strong dependency between the applications and the data 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 Durability means that effects of each successful transaction can be made permanent. incorrect MC Complete this sentence: In the three-layer architecture, between the external layer and the conceptual/logical layer, there is... The internal layer incorrect No independence, they are basically the same thing incorrect Physical data independence incorrect Logical data independence correct MC Which statement is NOT CORRECT? In a file approach to data management, the data definitions are included in each application separately. incorrect In a file approach to data management, different applications could be using older and newer versions of the same data. 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 What concept specifies the various data items, their characteristics and relationships, constraints, storage details, etc. and is specified during the database design? None of these concepts incorrect Database state incorrect Catalog incorrect Database model correct