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? Connection Manager correct Transaction Manager incorrect Buffer Manager incorrect 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.

Statement B: The first step of the DDL compiler is to translate the DDL definitions.

Which sentence(s) is/are right? Only A correct Only B incorrect A and B 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? Only A correct Only B incorrect A and B incorrect Neither A or B incorrect MC Evaluate the following statements:

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.
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.
3. Set-at-a-time DML means that the query gets set beforehand and then gets processed by the DBMS.
4. Set-at-a-time DML means that many records can be retrieved in one DML statement. 1 and 3 are right incorrect 2 and 3 are right incorrect 1 and 4 are right incorrect 2 and 4 are right correct MC Statement A: The impedance mismatch problem can be solved by using middleware to map data structures between the DBMS and the DDL statements.

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.

Which sentence(s) is/are correct? Only A incorrect Only B incorrect A and B incorrect Neither A or B correct 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? Only A incorrect Only B correct A and B incorrect Neither A or B incorrect MC Complete the following sentence, choosing the right words on place A and B.

When during crash recovery, aborted transactions need to be undone, that is a task of the ...A...
The part of the Storage manager that guarantees the ACID properties is the ...B... A: Lock manager, B: Recovery manager incorrect A: Lock manager, B: Lock manager incorrect A: Recovery manager, B: Buffer manager incorrect A: Recovery manager, B: Transaction manager correct MC CODASYL is an example of... A Hierarchical DBMS incorrect A Network DBMS correct A Relational DBMS incorrect An Object-Oriented DBMS incorrect MC Which of the following DBMS types is not a classification based on a data model? Hierarchical DBMS incorrect Network DBMS incorrect Cloud DBMS correct Object-Relational DBMS incorrect MC Statement A: In a Hierarchical DBMS, DML is declarative and set oriented with a query processor.

Statement B: In a relational DBMS, there is data independence between the conceptual and internal data model.

Which statement(s) is/are correct? Only A incorrect Only B correct A and B incorrect Neither A or B 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 Cloud DBMS incorrect Client-Server DBMS incorrect Federated DBMS correct 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 A incorrect Only B incorrect A and B correct Neither A or B 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.

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 Only B incorrect A and B incorrect Neither A or B incorrect