IBM Certification IBM Db2 Database Administration

Question 1

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

Accepted Answer

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

Answer

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

Question 2

In IBM Db2, what does the RUNSTATS utility do?

Accepted Answer

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

Answer

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.

Question 3

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

Accepted Answer

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

Answer

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

Question 4

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

Accepted Answer

Log Manager

Answer

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

Question 5

In IBM Db2, what is a 'tablespace'?

Accepted Answer

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

Answer

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.

IBM Certification Practice Test

IBM Certification Practice Test

IBM Certification IBM Db2 Database Administration