MC	Which of these is part of the Query Processor in the Architecture of a DBMS?	DDL compiler	incorrect	DML compiler	correct	Transaction Manager	incorrect	Security Manager	incorrect	
MC	Which of these is not a part of the Storage Manager in the DBMS Architecture?	Buffer Manager	incorrect	Connection Manager	correct	Recovery Manager	incorrect	Transaction Manager	incorrect	
MC	Which statement is CORRECT?	The buffer manager often uses the 80/20 rule that states that 20% of the time, 80% of the data is used.	incorrect	The DDL compiler parses DDL statements, checks them for syntactical correctness, translates them into internal format and then registers the data definitions into the catalog.	correct	The query rewriter optimizes the query based on the current database state.	incorrect	The heterogeneity of NoSQL databases is quite low.	incorrect	
MC	Which statement is NOT CORRECT?	Certain DBMS utilities are often available, such as performance monitoring, reorganization utility, user management and backup and recovery.	incorrect	The impedance mismatch problem can refer to the mapping between object-oriented and relational concepts. This can be solved by using middleware that maps the data structures to one-another.	incorrect	When implementing procedural DML, the system usually does not have a query processor.	incorrect	The buffer manager often uses the 80/20 rule that states that 20% of the time, 80% of the data is used.	correct	
MC	Statement A: The DDL compiler compiles data definitions specified in DDL.  It is possible that there is only 1 DDL with 3 instruction sets. <br><br> Statement B: The first step of the DDL compiler is to translate the DDL definitions.<br><br>Which sentence(s) is/are right?	Only B	incorrect	Neither A or B	incorrect	Only A	correct	A and B	incorrect	
MC	Which statement is NOT CORRECT?	In the hierarchical data model, the logical and internal data model are intertwined. 	incorrect	Native XML DBMSs take the logical structure from an existing XML document and turn this into a physical database. 	incorrect	An in-memory DBMS stores all data in internal memory instead of slower external storage such as disk-based storage.	incorrect	XML-enabled DBMSs allow to store XML data. However, we cannot query the XML data. 	correct	
MC	Which statement is CORRECT?	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	An object-relational DBMS (ORDBMS) extends an OODBMS with relational concepts. 	incorrect	An in-memory DBMS stores all data in internal memory instead of slower external storage such as disk-based storage.	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?	In the hierarchical data model, the logical and internal data model are intertwined. 	incorrect	An OLTP DBMS is mainly used for strategic and tactical decision making. 	correct	Native XML DBMSs take the logical structure from an existing XML document and turn this into a physical database. 	incorrect	A cloud DBMS architecture is advisable for smaller companies. 	incorrect	
MC	Which of these is part of the Query Processor in the Architecture of a DBMS?	DML compiler	correct	DDL compiler	incorrect	Transaction Manager	incorrect	Security Manager	incorrect