MC	Evaluate the following statements: <br><br> 1. Record-at-a-time DML means that the query gets recorded from the user at the time the user inputs the query and then gets processed. <br> 2. Record-at-a-time DML means that navigating the database starts with positioning on one specific record and going from there onwards to other records. <br> 3. Set-at-a-time DML means that the query gets set beforehand and then gets processed by the DBMS. <br> 4. Set-at-a-time DML means that many records can be retrieved in one DML statement.	2 and 3 are right	incorrect	2 and 4 are right	correct	1 and 3 are right	incorrect	1 and 4 are right	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	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: 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.<br><br> 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. <br><br>Which statement(s) is/are correct?	Only A	correct	A and B	incorrect	Neither A or B	incorrect	Only B	incorrect	
MC	Which of these is part of the Query Processor in the Architecture of a DBMS?	DDL compiler	incorrect	Transaction Manager	incorrect	DML compiler	correct	Security Manager	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: Recovery manager, B: Buffer manager	incorrect	A: Recovery manager, B: Transaction manager	correct	A: Lock manager, B: Lock manager	incorrect	A: Lock manager, B: Recovery manager	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?	Neither A or B	incorrect	A and B	incorrect	Only B	incorrect	Only A	correct	
MC	Evaluate the following statements: <br><br> 1. Record-at-a-time DML means that the query gets recorded from the user at the time the user inputs the query and then gets processed. <br> 2. Record-at-a-time DML means that navigating the database starts with positioning on one specific record and going from there onwards to other records. <br> 3. Set-at-a-time DML means that the query gets set beforehand and then gets processed by the DBMS. <br> 4. Set-at-a-time DML means that many records can be retrieved in one DML statement.	2 and 4 are right	correct	1 and 3 are right	incorrect	2 and 3 are right	incorrect	1 and 4 are right	incorrect	
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?	Only B	correct	Only A	incorrect	Neither A or B	incorrect	A and B	incorrect	
MC	Which of these is not a part of the Storage Manager in the DBMS Architecture?	Recovery Manager	incorrect	Connection Manager	correct	Transaction Manager	incorrect	Buffer Manager	incorrect