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

To store SQL execution plans permanently

Answer

To queue incoming database connections

Answer

To log all DDL statements

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

Runs statistical reports for IBM billing

Answer

Monitors CPU and memory in real time

Answer

Compresses tablespace data files

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

To reorganize employee org charts in HR systems

Answer

To reorganize database backup files on disk

Answer

To reorganize user permissions and roles

Question 4

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

Accepted Answer

Log Manager

Answer

Buffer Pool Manager

Answer

Catalog Manager

Answer

Agent Pool

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 virtual namespace for stored procedures

Answer

A schema for organizing user tables

Answer

A temporary area used only for sorting

Question 6

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

Accepted Answer

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

Answer

A backup compression algorithm

Answer

A high-speed network adapter for Db2

Answer

An automated index rebuild feature