IBM Db2 13 for z/OS Database Administrator Professional (C1000-181) Certification Sample Questions

The purpose of this Sample Question Set is to provide you with information about the IBM Db2 13 for z/OS Database Administrator - Professional exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the C1000-181 certification test. To get familiar with real exam environment, we suggest you try our Sample IBM Db2 13 for z/OS Database Administrator Professional Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual IBM Certified Db2 13 for z/OS Database Administrator - Professional certification exam.

These sample questions are simple and basic questions that represent likeness to the real IBM C1000-181 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium IBM Db2 13 for z/OS Database Administrator Professional Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.

IBM C1000-181 Sample Questions:

01. Native SQL procedure UPDATE_BALANCE has active version V1, and version V2 has just been added. One test program must run V2, while every production caller continues to run V1.

What should the test program issue?

a) ALTER PROCEDURE UPDATE_BALANCE ACTIVATE VERSION V2, commit, then CALL UPDATE_BALANCE

b) SET CURRENT ROUTINE VERSION = V2, then CALL UPDATE_BALANCE

c) SET CURRENT PATH = 'V2', then CALL UPDATE_BALANCE

d) SET CURRENT PACKAGESET = 'V2', then CALL UPDATE_BALANCE

02. SQL Data Insights is configured for a fraud-analytics team, and the AI object for table CLAIMS is enabled with a trained model. A query that uses AI_COMMONALITY returns its rows, but with SQLCODE +20577, reason code 1.

What should be done?

a) Rerun the DSNTIJAI sample job, then grant the AI function privileges again to the query's authorization ID

b) Rebind the package at a higher APPLCOMPAT level

c) Apply the z/OS APAR that AI_COMMONALITY requires, then retrain the model

d) Run RUNSTATS on the CLAIMS table

03. Before a release, every SQL statement in a new DBRM for program PAYCALC must be given full syntax and semantic checking against collection RELCOLL. The PAYCALC package already in RELCOLL must be neither dropped nor replaced by this check.

Which BIND PACKAGE option meets this requirement?

a) SQLERROR(CHECK)

b) VALIDATE(RUN)

c) VALIDATE(BIND)

d) SQLERROR(CONTINUE)

04. Every member of a credit union's data sharing group has been migrated to Db2 13, and fallback to Db2 12 is no longer needed. The team is preparing to activate function level V13R1M500.

In which order should these steps be performed?

a) 1) Issue -ACTIVATE FUNCTION LEVEL (V13R1M500) TEST and check DSNU757I 2) Generate the tailored jobs with the installation CLIST or DSNTIJBC 3) Run the tailored DSNTIJAF job 4) Rebind applications at APPLCOMPAT(V13R1M500)

b) 1) Generate the tailored jobs with the installation CLIST or DSNTIJBC 2) Run the tailored DSNTIJAF job 3) Issue -ACTIVATE FUNCTION LEVEL (V13R1M500) TEST and check DSNU757I 4) Rebind applications at APPLCOMPAT(V13R1M500)

c) 1) Rebind applications at APPLCOMPAT(V13R1M500) 2) Generate the tailored jobs with the installation CLIST or DSNTIJBC 3) Issue -ACTIVATE FUNCTION LEVEL (V13R1M500) TEST and check DSNU757I 4) Run the tailored DSNTIJAF job

d) 1) Generate the tailored jobs with the installation CLIST or DSNTIJBC 2) Issue -ACTIVATE FUNCTION LEVEL (V13R1M500) TEST and check DSNU757I 3) Run the tailored DSNTIJAF job 4) Rebind applications at APPLCOMPAT(V13R1M500)

05. An OLTP application with many read-only cursors must get as much concurrency and lock avoidance as possible, but it must never read uncommitted data.

Which bind option combination does IBM recommend for most applications such as this one?

a) ISOLATION(RR) CURRENTDATA(NO)

b) ISOLATION(UR) CURRENTDATA(NO)

c) ISOLATION(CS) CURRENTDATA(NO)

d) ISOLATION(CS) CURRENTDATA(YES)

06. Within one unit of recovery, a program issues SAVEPOINT SP1 ON ROLLBACK RETAIN CURSORS before each of three batches of inserts. After the third batch, it issues ROLLBACK TO SAVEPOINT SP1.

Which inserts are backed out?

a) Only the third batch, because each new SP1 replaced the previous one

b) Only the second and third batches, because SP1 now names the second savepoint

c) All three batches, because Db2 rolls back to the first savepoint named SP1

d) None; the second SAVEPOINT SP1 failed with SQLCODE -881

07. Under subsystem type DDF, a WLM classification rule with qualifier PR = PAYPROC assigns service class PRDONLIN. Remote transactions whose first statement calls PAYPROC run in PRDONLIN, but transactions that issue a SELECT and then call PAYPROC do not.

Why is the second group not classified to PRDONLIN?

a) The rule must be defined under subsystem type STC instead

b) PR applies only when the first SQL statement in the unit of work is a CALL

c) A PR rule also needs a CN rule for the procedure's package collection

d) PR rules apply only to procedures called by local CICS or TSO work

08. In one thread, package PKGA, bound with RELEASE(DEALLOCATE), and package PKGB, bound with RELEASE(COMMIT), both use static SQL against partitioned table space TSORD1, which is defined with LOCKSIZE ROW.

Which two (2) statements are true?

(Choose two.)

a) PKGA's row locks on TSORD1 are held until the thread terminates

b) Most dynamic statements in PKGA would also keep their locks until thread termination

c) PKGB's partition locks on TSORD1 are released at each commit point

d) RELEASE affects neither package's row locks

e) All partition locks on TSORD1 are held until deallocation, including those taken for PKGB

09. REST service versioning is enabled. Version v1 of service CLAIMS.getClaimStatus was created first and is the default; version v2 has just been bound with BIND SERVICE. Clients that call /services/CLAIMS/getClaimStatus without a version must now get v2, while clients that name v1 must keep working.

What should the DBA do?

a) Rebind the v2 package with RESTSERVICEDEFAULT(YES)

b) Bind v2 again with BIND SERVICE, which makes the newest version the default

c) Issue FREE SERVICE for v1 so that v2 becomes the only version

d) Run sample job DSNTIJR2 again so that versioning sets a new default

10. Function level 500 is active, and AI query is enabled for table VEHICLE_RENTALS with a trained model. A SELECT that returns RENTAL_ID and an AI_SIMILARITY score runs successfully, but a CREATE VIEW defined on that same SELECT fails with SQLCODE -154.

What explains the failure?

a) Function level 500 must be activated before a view can reference the function

b) A view definition cannot reference AI_SIMILARITY or the other SQL Data Insights functions, so the view is not defined

c) AI_SIMILARITY is not deterministic, so the view needs WITH CHECK OPTION

d) AI query must first be enabled for the view itself, as a separate AI object

Answers:

Question: 01 Answer: b	Question: 02 Answer: c	Question: 03 Answer: a	Question: 04 Answer: d	Question: 05 Answer: c
Question: 06 Answer: a	Question: 07 Answer: b	Question: 08 Answer: d, e	Question: 09 Answer: a	Question: 10 Answer: b

Note: For any error in IBM Certified Db2 13 for z/OS Database Administrator - Professional (C1000-181) certification exam sample questions, please update us by writing an email on feedback@edusum.com.