MC	CODASYL is an example of...	A Relational DBMS	incorrect	A Hierarchical DBMS	incorrect	A Network DBMS	correct	An Object-Oriented DBMS	incorrect	
MC	Statement A: The impedance mismatch problem can be solved by using middleware to map data structures between the DBMS and the DDL statements. <br><br> Statement B: An object-oriented host language such as Java combined with a document-oriented DBMS such as MongoDB does not require mapping objects to documents and vice versa. <br><br> Which sentence(s) is/are correct?	A and B	incorrect	Only B	incorrect	Neither A or B	correct	Only A	incorrect	
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. <br><br> 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.<br><br> Which statement(s) is/are correct?	Only A	incorrect	Only B	incorrect	Neither A or B	incorrect	A and B	correct	
MC	Which statement is CORRECT?	An in-memory DBMS stores all data in internal memory instead of slower external storage such as disk-based storage.	correct	An object-relational DBMS (ORDBMS) extends an OODBMS with relational concepts. 	incorrect	In an OODBMS, an object encapsulates both data and functionality. However, an impedance mismatch can occur when working with an object-oriented programming language.	incorrect	NoSQL includes all databases that do not use SQL. They are created to be more scalable and deal with stable data structures. 	incorrect	
MC	Which statement is CORRECT?	The lock manager is responsible to ensure the ACID properties.	incorrect	The connection manager sets up a database connection and verifies the logon credentials and the privileges.	incorrect	The query rewriter optimizes the query based on the current database state.	incorrect	The recovery manager keeps track of all the database operations in a logfile.	correct	
MC	Which statement is CORRECT?	The query rewriter optimizes the query based on the current database state.	incorrect	The lock manager is responsible to ensure the ACID properties.	incorrect	The connection manager sets up a database connection and verifies the logon credentials and the privileges.	incorrect	The recovery manager keeps track of all the database operations in a logfile.	correct	
MC	Which statement is NOT CORRECT?	An RDBMS has full separation between the logical and internal data model. 	incorrect	XML-enabled DBMSs allow to store XML data. However, we cannot query the XML data. 	correct	The recovery manager keeps track of all the database operations in a logfile.	incorrect	When implementing procedural DML, the system usually does not have a query processor.	incorrect	
MC	Which statement is CORRECT?	In procedural DML, the application developer needs to know the details of the DBMS to be able to write efficient queries.	correct	An OLTP DBMS is mainly used for strategic and tactical decision making. 	incorrect	XML-enabled DBMSs allow to store XML data. However, we cannot query the XML data. 	incorrect	The federated DBMS architecture is a straightforward extension of the client-server architecture. Often a client with GUI functionality, an application server, a database server and a web server are present in this setup. 	incorrect	
MC	Which statement is CORRECT?	An RDBMS has full separation between the logical and internal data model. 	correct	XML-enabled DBMSs allow to store XML data. However, we cannot query the XML data. 	incorrect	In the network data model, the DML is declarative. 	incorrect	The federated DBMS architecture is a straightforward extension of the client-server architecture. Often a client with GUI functionality, an application server, a database server and a web server are present in this setup. 	incorrect	
MC	Statement A: There is no query processor available in procedural DML. <br><br> Statement B: With procedural DML, the DBMS determines the access path and navigational strategy to locate and modify the data specified in the query.<br><br>Which sentence(s) is/are right?	Neither A or B	incorrect	Only A	correct	Only B	incorrect	A and B	incorrect