Practice Test GeeksIBM Certification Practice Test
← All IBM Certification Flashcard Decks

IBM Db2 Database Administration Flashcards

6 cards from real IBM Certification practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 IBM Db2 Database Administration flashcards as text

  1. What is the primary role of the IBM Db2 'buffer pool' in database performance?

    Answer: To cache frequently accessed data pages in memory, reducing disk I/O

    The Db2 buffer pool is a memory area that caches recently accessed data pages, minimizing expensive disk reads and improving query performance.

  2. In IBM Db2, what does the RUNSTATS utility do?

    Answer: Collects catalog statistics about table and index data distribution to help the optimizer choose efficient query plans

    RUNSTATS collects and stores statistical information about tables and indexes in the Db2 catalog, enabling the query optimizer to select the most efficient execution plans.

  3. What is the purpose of the IBM Db2 'REORG' utility?

    Answer: To physically reorganize table or index data to eliminate fragmentation and reclaim space

    The REORG utility physically reorganizes table or index data, eliminating fragmentation caused by inserts, updates, and deletes to improve performance and reclaim space.

  4. Which Db2 component is responsible for writing committed transactions to disk to ensure durability?

    Answer: Log Manager

    The Db2 Log Manager writes transaction log records to disk, ensuring committed transactions are durable and recoverable after a system failure.

  5. In IBM Db2, what is a 'tablespace'?

    Answer: A logical storage structure that maps to one or more physical database container files

    A Db2 tablespace is a logical storage object that defines where tables are physically stored, mapping to one or more container files or raw disk devices.

  6. What does IBM Db2 'High Availability Disaster Recovery' (HADR) provide?

    Answer: Log shipping-based replication between a primary and standby database for failover

    Db2 HADR ships transaction logs from a primary database to one or more standby databases, enabling automatic failover to maintain availability during outages.