IBM Db2 12 for z/OS DBA Fundamentals (C1000-122) Certification Sample Questions

The purpose of this Sample Question Set is to provide you with information about the IBM Db2 12 for z/OS DBA Fundamentals exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the C1000-122 certification test. To get familiar with real exam environment, we suggest you try our Sample IBM Db2 12 for z/OS DBA Fundamentals 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 Associate Certified DBA - Db2 12 for z/OS Fundamentals certification exam.

These sample questions are simple and basic questions that represent likeness to the real IBM C1000-122 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium IBM Db2 12 for z/OS DBA Fundamentals 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-122 Sample Questions:

01. Package PGM7 is bound in collection TESTCOLL. It must now also exist in collection QACOLL, and the DBRM it was originally bound from is no longer available.

Which command creates the package in QACOLL?

a) REBIND PACKAGE(TESTCOLL.PGM7)

b) BIND PACKAGE(QACOLL) COPY(TESTCOLL.PGM7)

c) BIND PACKAGE(TESTCOLL) COPY(TESTCOLL.PGM7) ACTION(REPLACE)

d) BIND PACKAGE(QACOLL) MEMBER(PGM7) ACTION(ADD)

02. Halfway through a long-running batch job, a declared temporary table named TEMPPROD must be removed completely, definition included, so that the program can declare a table with different columns under the same name. The program must not commit at this point.

Which statement removes the table?

a) COMMIT under the default ON COMMIT DELETE ROWS

b) DELETE FROM SESSION.TEMPPROD with no WHERE clause

c) DROP TABLE TEMPPROD

d) DROP TABLE SESSION.TEMPPROD

03. Unique index XSTAFF1 on STAFF(STAFFNO) enforces the primary key. A frequent query selects STAFFNO and EXTN for a given STAFFNO, and it should use index-only access while uniqueness is still enforced on STAFFNO alone.

Which statement meets both needs?

a) ALTER INDEX XSTAFF1 CLUSTER, then a REORG of the table space

b) ALTER INDEX XSTAFF1 ADD INCLUDE COLUMN (EXTN)

c) ALTER INDEX XSTAFF1 ADD COLUMN (EXTN)

d) RUNSTATS INDEX(XSTAFF1), then a rebind of the query's package

04. Right after CREATE VIEW SALES.V_REGION completes, which two (2) catalog tables each hold a row for every object on which the view depends?

(Choose two.)

a) SYSIBM.SYSCOLUMNS

b) SYSIBM.SYSVIEWDEP

c) SYSIBM.SYSVIEWS

d) SYSIBM.SYSTABAUTH

e) SYSIBM.SYSDEPENDENCIES

05. A document intake job inserts an XML document from host variable :HV into an XML column. Every whitespace character between the elements must be kept exactly as received.

Which expression should the VALUES clause use?

a) XMLPARSE(DOCUMENT :HV PRESERVE WHITESPACE)

b) XMLPARSE(DOCUMENT :HV STRIP WHITESPACE)

c) XMLPARSE(DOCUMENT :HV)

d) XMLSERIALIZE(:HV AS CLOB)

06. Table space ORDTS is defined with LOCKSIZE PAGE. Online transactions that update different orders stored on the same data pages frequently time out and deadlock, and monitoring shows that no lock escalation occurs.

Which change to ORDTS addresses the problem?

a) Alter it to use LOCKSIZE TABLESPACE

b) Alter it to the default LOCKSIZE ANY

c) Alter it to LOCKSIZE ROW

d) Specify LOCKMAX 0

07. Within one unit of recovery, a program sets savepoints A, B and C in that order, making changes after each one. It then issues RELEASE SAVEPOINT B, makes further changes and issues ROLLBACK TO SAVEPOINT with no savepoint name.

Which changes does the rollback back out?

a) All changes made since savepoint A was set, with the unit of recovery left open

b) All changes made since savepoint B was set

c) All changes since the last commit point, and the unit of recovery ends

d) Only the changes made after savepoint C was set

08. In a retail data warehouse, the nightly ETL process already guarantees that every SALES row matches a row in STORE. The DBA wants Db2 to know about the relationship so that more queries qualify for rewrite to materialized query tables, without Db2 spending effort to check it.

How should the relationship be defined?

a) No foreign key at all

b) A foreign key on SALES defined with ON DELETE NO ACTION

c) A foreign key, with LOAD ENFORCE NO

d) A foreign key on SALES defined with NOT ENFORCED

09. Yesterday ALTER TABLESPACE DBBILL.TSINV BUFFERPOOL BP8K0 was issued for a billing table space that uses 4 KB pages. The change is pending, TSINV is in AREOR status and no REORG has run. The change is now cancelled, and TSINV must keep its current definition with AREOR removed.

Which statement should be issued?

a) REORG TABLESPACE DBBILL.TSINV

b) REPAIR SET TABLESPACE DBBILL.TSINV NOCHECKPEND

c) ALTER TABLESPACE DBBILL.TSINV DROP PENDING CHANGES

d) -START DATABASE(DBBILL) SPACENAM(TSINV)

10. During a phased rollout, the old and new load modules of program ORD01 must both run against packages in collection COLLORD. The plan must not be rebound, its package list must not change and the program must not issue SET CURRENT PACKAGESET.

How should the two program versions be prepared?

a) Bind the new DBRM into a second collection and have the new program switch to it with SET CURRENT PACKAGESET

b) Rebind the existing ORD01 package with PLANMGMT(EXTENDED) so that old and new access paths are both retained

c) Bind the new DBRM into COLLORD with ACTION(REPLACE), replacing the existing ORD01 package in place

d) Precompile each version with the VERSION option and bind both DBRMs into COLLORD

Answers:

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

Note: For any error in IBM Associate Certified DBA - Db2 12 for z/OS Fundamentals (C1000-122) certification exam sample questions, please update us by writing an email on feedback@edusum.com.