Multiple choice technology databases

Which Database Services component manages the physical database

  1. DBRM

  2. Buffer Manager

  3. Runtime Supervisor

  4. Data Manager
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Data Manager component handles physical database operations - reading from and writing to disk, managing page buffers, and coordinating with the Buffer Manager. It's responsible for all I/O operations and physical data access.

AI explanation

In DB2 (and similar relational DBMS) architecture, the Data Manager component is responsible for managing the physical database — handling access to rows and pages, enforcing referential integrity, managing locking at the row/page level, and interfacing between the higher-level relational data system (which parses SQL) and the Buffer Manager (which handles caching of pages in memory). DBRM (Database Request Module) is a compiled SQL artifact from precompilation, not a runtime component managing physical storage; Buffer Manager specifically handles page caching/I/O, a narrower role than 'managing the physical database' as a whole; and Runtime Supervisor coordinates thread/task execution, not physical data structures. Data Manager is the correct, broader physical-database-management component.

Keep practicing — related questions