Which product has an open-source license in addition to having a non-relational system
Correct Answer: A
Explanation:
MongoDB is a NoSQL (non-relational) database that is open-source and supports document-oriented storage. It allows for flexible schema design and is optimized for big data applications. Option A (Correct): MongoDB is a NoSQL database with an open-source AGPL license, making it both free to use and non-relational. Option B (Incorrect): SQL Server is a relational database (RDBMS) developed by Microsoft and is not open-source. Option C (Incorrect): MySQL is open-source but is a relational database (RDBMS), not a NoSQL system. Option D (Incorrect): Oracle Database is relational and proprietary (not open-source). Reference: Database Management Systems Comparison.
Question 2
What is the role of the transaction manager within the database system architecture?
Correct Answer: C
Explanation:
A Transaction Manager ensures ACID (Atomicity, Consistency, Isolation, Durability) properties in database transactions. It manages concurrent transactions, ensuring no conflicts occur and logs modifications to support recovery mechanisms. Option A (Incorrect): Query optimization is managed by the query processor, not the transaction manager. Option B (Incorrect): The transaction manager is a component of the database architecture but is not composed of the entire system (query processor, storage manager, etc.). Option C (Correct): The transaction manager logs transactions like INSERT, UPDATE, and DELETE, ensuring consistency and recoverability. Option D (Incorrect): The storage manager is responsible for translating queries into file system commands. Reference: Transaction Management section in SE 3050 zyBooks.
Demo Practice Mode
You are viewing only the questions marked as Demo.