Skip to content
Quizra

C1000-122 Db2 12 for z/OS DBA Fundamentals Practice Questions

Prepare for C1000-122 with more than an answer.

138 questions in the full set12 sample questionsUpdated Mar 12, 2026
Study as flashcards
Exam fee
$200 USD
Time limit
90 minutes
Questions on the exam
63
Passing score
44 out of 63
Level
Associate
Valid for
Not specified by IBM
Domains covered on the exam 7
  1. Planning11%
  2. Working with SQL and XML21%
  3. Security8%
  4. Operations16%
  5. Data Concurrency11%
  6. Application Design21%
  7. Working with Database Objects12%
  1. 1

    A stored procedure needs to insert data into a table and automatically include the ID of the user who executed the procedure. The procedure is defined with RUN OPTIONS 'Owner' but the requirement is to capture the actual invoker's ID, not the owner of the package. Which special register should be used in the INSERT statement?

    Show answer details

    Correct answer: B

    SESSION_USER (or USER) returns the authorization ID of the user who connected to the subsystem (the primary authorization ID of the process). CURRENT SQLID often reflects the owner of the plan/package if DYNAMICRULES(BIND) is used or if SET CURRENT SQLID was issued, so SESSION_USER is safer for auditing the actual invoker.

  2. 2

    You are writing a query to concatenate a list of email addresses for a specific department into a single string, separated by semicolons. Which aggregate function in Db2 12 is designed for this specific purpose?

    Show answer details

    Correct answer: B

    LISTAGG is an aggregate function that transforms a group of rows into a list of values separated by a specified delimiter.

  3. 3

    Consider the following query:

    SELECT COALESCE(SUM(SALARY), 0)
FROM EMPLOYEES
WHERE DEPT_ID = 999;

    If no employees exist in department 999, what result will this query return?

    Show answer details

    Correct answer: B

    The SUM aggregate function returns NULL if the result set is empty (no rows match the WHERE clause). The COALESCE function then checks this result; since it is NULL, it returns the second argument, which is 0.

  4. 4

    A financial institution is designing a high-availability architecture using a Db2 12 for z/OS Data Sharing Group. The architecture team needs to ensure that the Coupling Facility (CF) structures are correctly defined to handle inter-Db2 read/write interest efficiently. Specifically, they are concerned about the mechanism used to track page validity across the group buffer pools. Which specific component of the Coupling Facility is primarily responsible for registering interest in pages and ensuring data coherency across members, and what happens when a page is updated by one member?

    Show answer details

    Correct answer: C

    In a Db2 Data Sharing environment, the Group Buffer Pool (GBP), which resides in the Coupling Facility's Cache Structure, is responsible for maintaining data coherency. It uses directory entries to track which members have a copy of a page (interest). When a member updates a page, it writes the changed page to the GBP, which then signals 'cross-invalidation' (XI) to other members holding that page in their local buffer pools, marking their copies as invalid.

  5. 5

    A Database Administrator is creating a new table space for a transaction history table that is expected to grow to 500 TB over the next five years. The table will be heavily inserted into and queried by range of dates. The DBA decides to use a Partition-by-Range (PBR) Universal Table Space (UTS) with Relative Page Numbering (RPN). What is the primary architectural advantage of selecting RPN for this specific scenario compared to absolute page numbering?

    Show answer details

    Correct answer: B

    Relative Page Numbering (RPN) in Db2 12 PBR UTS removes the dependency between the partition size and the number of partitions. With absolute page numbering, increasing the number of partitions often required decreasing the maximum partition size to stay within the 4-byte RID limit. RPN expands the RID capability, allowing both maximum partition count (up to 4096) and large partition sizes (up to 1 TB) simultaneously.

  6. 6

    A systems programmer is preparing to modify a subsystem parameter (ZPARM) to increase the maximum number of open datasets (DSMAX). The environment requires 24/7 availability. Which method allows the change to take effect immediately without stopping and starting the Db2 subsystem?

    Show answer details

    Correct answer: A

    Most ZPARMs in Db2 12, including DSMAX, are online changeable. The process involves updating the DSNZPARM source, assembling and linking it to a load module (typically with a new name or replacing the existing one), and then issuing the -SET SYSPARM command to reload the parameters dynamically.

Create an account to continue.

Create accountSign in

Keep going

Related exams