Book Image

IBM Db2 11.1 Certification Guide

By : Robert (Kent) Collins, Mohankumar Saraswatipura
Book Image

IBM Db2 11.1 Certification Guide

By: Robert (Kent) Collins, Mohankumar Saraswatipura

Overview of this book

IBM Db2 is a relational database management system (RDBMS) that helps you store, analyze, and retrieve data efficiently. This comprehensive book is designed to help you master all aspects of IBM Db2 database administration and prepare you to take and pass IBM's Certification Exams C2090-600. Building on years of extensive experience, the authors take you through all areas covered by the test. The book delves deep into each certification topic: Db2 server management, physical design, business rules implementation, activity monitoring, utilities, high availability, and security. IBM Db2 11.1 Certification Guide provides you with more than 150 practice questions and answers, simulating real certification examination questions. Each chapter includes an extensive set of practice questions along with carefully explained answers. This book will not just prepare you for the C2090-600 exam but also help you troubleshoot day-to-day database administration challenges.
Table of Contents (10 chapters)

Answers

Question 1

The correct answer is C. To enable log file mirroring, you simply assign the fully qualified name of the mirror log location (path) to the mirrorlogpath database configuration parameter.

Question 2

The correct answer is B. When a transaction failure occurs, all work done by partially completed transactions that have not yet been externalized to the database is lost. The database might be left in an inconsistent state (and therefore will be unusable). Crash recovery is the process used to return such a database to a consistent and usable state. To perform crash recovery, you must use information stored in the transaction log files to complete any committed transactions that were in memory (but had not yet been externalized to storage) when the transaction failure occurred, roll back any incomplete transactions, and purge any uncommitted transactions from memory...