ExamDumpster

Free C1000-122 sample questions

Try these free C1000-122 sample questions, each with the right answer and a short explanation. They touch on Db2 SQL, transactions and locking, and Db2 commands and utilities. Note the Db2 12 topics you miss, and study those first.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 6 of 12 free sample questions.

Question 1Choose one

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?

Question 2Choose one

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?

Question 3Choose one

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?

Question 4Choose one

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?

Question 5Choose one

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?

Question 6Choose one

Consider the following query: ```sql SELECT COALESCE(SUM(SALARY), 0) FROM EMPLOYEES WHERE DEPT_ID = 999; ``` If no employees exist in department 999, what result will this query return?

6 more free samples are waiting

Create a free account to unlock the whole C1000-122 sample bank, or get full access to all 138 practice questions in the simulator.

Create account