IBM Certification IBM Db2 Database Administration 2

Question 1

What is the difference between 'BACKUP' and 'EXPORT' in IBM Db2?

Accepted Answer

BACKUP creates an offline copy of the entire database; EXPORT writes table data to a file in a portable format

Answer

They are identical commands with different names

Answer

BACKUP is for indexes only; EXPORT is for tables only

Answer

BACKUP requires root access; EXPORT does not

Question 2

In IBM Db2, what is the purpose of the 'db2diag.log' file?

Accepted Answer

Recording diagnostic and error messages from the Db2 instance for troubleshooting

Answer

Storing user query results

Answer

Logging all SELECT statements issued

Answer

Tracking license usage metrics

Question 3

What does the Db2 'EXPLAIN' facility provide to a DBA?

Accepted Answer

The query execution plan showing how the optimizer will access tables and indexes

Answer

A human-readable explanation of Db2 licensing terms

Answer

The list of all users connected to the database

Answer

The explanation of syntax errors in SQL statements

Question 4

Which Db2 command is used to list all active database connections on an instance?

Accepted Answer

LIST APPLICATIONS

Answer

LIST CONNECTIONS

Answer

SHOW SESSIONS

Answer

GET CONNECTIONS

Question 5

What is IBM Db2's 'autonomic computing' feature known as 'Self-Tuning Memory Manager' (STMM)?

Accepted Answer

A feature that dynamically adjusts memory allocations between buffer pools and internal memory heaps based on workload

Answer

A feature that automatically patches Db2 software

Answer

A feature that self-heals corrupted data pages

Answer

A feature that automatically creates indexes based on query patterns

Question 6

In IBM Db2, what is 'row compression' used for?

Accepted Answer

Reducing the physical storage size of table rows using a dictionary-based compression algorithm

Answer

Compressing backup files

Answer

Encrypting sensitive column data

Answer

Compressing index entries for faster lookups