MC What concept specifies the various data items, their characteristics and relationships, constraints, storage details, etc. and is specified during the database design? Database state incorrect Database model correct Catalog incorrect None of these concepts 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.

Statement B: SQL is a DML language to retrieve, insert, delete and modify data. It is stored in the catalog.

Which sentence(s) is/are right? Only B incorrect Only A incorrect Neither A or B correct A and B 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, maintenance of data and metadata is easier. incorrect 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 MC Which statement is CORRECT? ACID stands for Availability, Consistency, Isolation and Durability. incorrect The file-based approach uses metadata to define the data. These definitions are then stored in a catalog. incorrect Only structured data can be described in a formal logical data model. correct It is more cumbersome to query a database system than a file-based system. incorrect MC Which statement is NOT CORRECT? 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 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 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? 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 In a file approach to data management, the data definitions are included in each application separately. incorrect MC Which statement is CORRECT? In a file approach to data management, different applications could be using older and newer versions of the same data. correct The file-based approach uses metadata to define the data. These definitions are then stored in a catalog. incorrect The response time is the time needed to build the conceptual data model. incorrect The database state specifies the various data items, their characteristiscs and relationships and is specified during the database design. incorrect 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, a change in the structure of a data file is easily handled because each application has its own data files. correct 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