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 difference between 'BACKUP' and 'EXPORT' in IBM Db2?

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

    BACKUP creates a full binary copy of the entire Db2 database for recovery purposes, while EXPORT writes table data to an external file in formats like CSV or IXF.

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

    Answer: Recording diagnostic and error messages from the Db2 instance for troubleshooting

    The db2diag.log file is Db2's primary diagnostic log, recording internal errors, warnings, and informational messages used for troubleshooting and support.

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

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

    The EXPLAIN facility captures the query access plan chosen by the Db2 optimizer, showing table scan vs. index access methods, join strategies, and estimated costs.

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

    Answer: LIST APPLICATIONS

    The `LIST APPLICATIONS` command displays all applications currently connected to Db2 databases on the instance, including their agent IDs and connection details.

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

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

    STMM dynamically reallocates memory between buffer pools, the sort heap, and other memory consumers based on real-time workload demands, optimizing memory usage automatically.

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

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

    Db2 row compression uses a dictionary-based algorithm to compress repeated data patterns within table rows, reducing storage footprint and improving I/O efficiency.