C1000-122 Sample Questions

C1000-122 Sample Questions & Answers

SQL and XML statements, stored procedures and triggers share the heaviest weight, alongside planning Db2 subsystems, restricting data access, Db2 commands and utilities, handling locks and concurrency in transactions, and database objects.

Launch the full C1000-122 simulator →

Showing 6 of 12 free samples.

  1. Question 1Beginner

    Planning · Understand DB2 architecture

    While investigating a performance issue in a Db2 12 environment, a DBA observes high CPU usage in the ssnmDIST address space. Which type of workload is most likely generating this activity?

    Show answer & explanation

    Correct answer: D

    The ssnmDIST address space (Distributed Data Facility) handles remote connections and distributed workloads coming into Db2 via TCP/IP or SNA using the DRDA protocol. High CPU in this address space indicates heavy distributed workload processing.

  2. Question 2AdvancedSelect 2

    Planning · Connect to DB2 servers

    A DBA needs to configure connectivity for a new Java application running on Linux to a Db2 for z/OS subsystem. The application requires high availability and workload balancing across the data sharing group. Which TWO configuration items are essential on the client side (e.g., IBM Data Server Driver) to enable Sysplex Workload Balancing? (Select TWO)

    Show answer & explanation

    Correct answers: A, D

    The initial connection must be made to the Group VIPA (Distributor IP) and use the Group Location Name to allow the client to discover the members of the data sharing group.

    To enable Sysplex Workload Balancing, the client driver property enableSysplexWLB must be set to true.

  3. Question 3Intermediate

    Working with SQL and XML · Understand DML SQL statement

    Analyze the following SQL query used in a sales report. The requirement is to rank sales representatives by their total sales within each region, but gaps in ranking numbers should be avoided if two representatives have the exact same sales total.

    SELECT REGION, SALES_REP, TOTAL_SALES,
________(ORDER BY TOTAL_SALES DESC) OVER (PARTITION BY REGION) as RANKING
FROM SALES_DATA

    Which OLAP function correctly fills the blank to meet the requirement?

    Show answer & explanation

    Correct answer: C

    The DENSE_RANK function assigns a rank to each row within a partition of a result set, with no gaps in the ranking values. If two rows tie for rank 1, the next rank is 2. RANK would produce a gap (e.g., 1, 1, 3).

  4. Question 4Intermediate

    Working with SQL and XML · Demonstrate knowledge of built-in functions

    A developer needs to retrieve specific elements from an XML document stored in a Db2 table column named CUSTOMER_DATA. The requirement is to extract the ZipCode element from the Address node for all customers. Which SQL function should be used to return the value as a relational column in the result set?

    Show answer & explanation

    Correct answer: D

    To return an XML element value as a standard SQL data type (like VARCHAR or INTEGER) in the result set, XMLQUERY is used to locate the node, wrapped in XMLCAST to convert the XML sequence to a relational scalar type.

  5. Question 5Intermediate

    Working with SQL and XML · Demonstrate knowledge of built-in functions

    A table EMPLOYEE_JSON contains a CLOB column DATA holding JSON documents. The document structure is {"employee": {"id": 101, "skills": ["Java", "Db2"]}}. A developer wants to retrieve the first skill for each employee using a SQL statement. Which function is most appropriate?

    Show answer & explanation

    Correct answer: A

    The JSON_VAL function (or JSON_VALUE) is used to extract a scalar value from a JSON document. The path expression employee.skills[0] correctly targets the first element of the skills array.

  6. Question 6Advanced

    Working with SQL and XML · Understand DML SQL statement

    An application issues a MERGE statement to synchronize a target table with a source table. The requirement is to UPDATE existing rows if the ID matches and INSERT new rows if the ID does not exist. However, the application receives a SQLCODE -788 (Merge statement failed because the same row of target table was identified for update or delete more than once). What is the most likely cause of this error?

    Show answer & explanation

    Correct answer: B

    The MERGE statement requires that each row in the target table be operated on at most once. If the source data set has duplicate rows based on the join condition (the ON clause), Db2 attempts to update the same target row multiple times within the same statement execution, which is prohibited and results in SQLCODE -788.

Ready for the real thing?

The full C1000-122 simulator has every exam-style question, timed mode, and instant scoring.

Go to the C1000-122 simulator →