MC Statement A: An OLTP system is able to cope with real-time, simultaneous transactions which the database server is able to process in a huge volume.
Statement B: An OLAP system uses large amounts of operational data to run complex queries on and provide insights for tactical and strategical decision making.
Which statement(s) is/are correct? Only B incorrect A and B correct Only A incorrect Neither A or B incorrect
MC Statement A: There is no query processor available in procedural DML.
Statement B: With procedural DML, the DBMS determines the access path and navigational strategy to locate and modify the data specified in the query.
Which sentence(s) is/are right? A and B incorrect Only A correct Only B incorrect Neither A or B incorrect
MC Which of the following DBMS types is not a classification based on a data model? Hierarchical DBMS incorrect Object-Relational DBMS incorrect Cloud DBMS correct Network DBMS incorrect
MC Which of the following DBMS types is not a classification based on a data model? Object-Relational DBMS incorrect Network DBMS incorrect Cloud DBMS correct Hierarchical DBMS incorrect
MC If you want to use a DBMS architecture that can access multiple data sources itself and provides a uniform interface hiding the low-level details, the most appropriate DBMS would be a... n-tier DBMS incorrect Federated DBMS correct Client-Server DBMS incorrect Cloud DBMS incorrect
MC Which of the following DBMS types is not a classification based on a data model? Object-Relational DBMS incorrect Network DBMS incorrect Cloud DBMS correct Hierarchical DBMS incorrect
MC Statement A: The Query Parser optimizes and simplifies a query and then passes it on to the Query Executor.
Statement B: In the DBMS architecture, the Storage Manager takes care of concurrency control.
Which sentence(s) is/are correct? A and B incorrect Only A incorrect Neither A or B incorrect Only B correct
MC Which of the following DBMS types is not a classification based on a data model? Hierarchical DBMS incorrect Cloud DBMS correct Network DBMS incorrect Object-Relational DBMS incorrect
MC Which of the following DBMS types is not a classification based on a data model? Hierarchical DBMS incorrect Object-Relational DBMS incorrect Network DBMS incorrect Cloud DBMS correct
MC Statement A: Native XML DBMSs map the hierarchical structure of an XML document to a physical storage structure, because they are able to use the intrinsic structure of an XML document.
Statement B: XML-enabled DBMSs are able to store XML data in an integrated and transparent way, because they are able to use the intrinsic structure of an XML document.
Which statement(s) is/are correct? Only A correct A and B incorrect Neither A or B incorrect Only B incorrect