MC	Statement A: The Query Parser optimizes and simplifies a query and then passes it on to the Query Executor. <br><br> Statement B: In the DBMS architecture, the Storage Manager takes care of concurrency control. <br><br> Which sentence(s) is/are correct?	A and B	incorrect	Neither A or B	incorrect	Only A	incorrect	Only B	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	A and B	incorrect	Neither A or B	incorrect	Only A	correct	
MC	CODASYL is an example of...	A Relational DBMS	incorrect	A Network DBMS	correct	A Hierarchical DBMS	incorrect	An Object-Oriented DBMS	incorrect	
MC	Complete the following sentence, choosing the right words on place <b>A</b> and <b>B</b>.<br><br>When during crash recovery, aborted transactions need to be undone, that is a task of the ...<b>A</b>... <br> The part of the Storage manager that guarantees the ACID properties is the ...<b>B</b>...	A: Lock manager, B: Lock manager	incorrect	A: Lock manager, B: Recovery manager	incorrect	A: Recovery manager, B: Buffer manager	incorrect	A: Recovery manager, B: Transaction manager	correct	
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?	A and B	incorrect	Only B	incorrect	Neither A or B	incorrect	Only A	correct	
MC	Statement A: In a Hierarchical DBMS, DML is declarative and set oriented with a query processor. <br><br> Statement B: In a relational DBMS, there is data independence between the conceptual and internal data model. <br><br> Which statement(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?	Object-Relational DBMS	incorrect	Network DBMS	incorrect	Cloud DBMS	correct	Hierarchical 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?	Neither A or B	correct	Only A	incorrect	A and B	incorrect	Only B	incorrect	
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	Only A	correct	Neither A or B	incorrect	A and B	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?	A and B	incorrect	Only B	incorrect	Neither A or B	incorrect	Only A	correct