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. Which option will materialize pending data definition changes?

a) DROP

b) Run REORG

c) Recycle Db2

d) Deactivate the database

02. Which two online utilities create a Db2 registered backup image that can be used to restore a table space to a point in time?

(Choose Two)

a) COPY

b) UNLOAD

c) RECOVER

d) DSN1COPY

e) BACKUP SYSTEM

03. What method is used for remote access with Db2?

a) DRDA

b) LINK

c) ATTACH

d) PRIVATE PROTOCOL

04. Which statement describes online utilities?

a) Utilities that can only run using JCL.

b) Utilities that requires Db2 to be up and running.

c) Only utilities that are using SHRLEVEL REFERENCE option.

d) Utilities that work directly on the data sets independent of Db2.

05. In order to store a JSON document in a Db2 for z/OS column in a binary format that can be indexed and searched, what type of column must the document be stored in?

a) CHAR

b) BIGINT

c) BLOB

d) INTEGER

06. Utility privileges are granted at what level?

a) Database

b) Table

c) Subsystem

d) Table space

07. Which statement describes a unit of work?

a) It is initiated by the OPEN CURSOR statement.

b) It is only initiated by the CONNECT statement.

c) It is initiated by the first SELECT statement.

d) It is a recoverable sequence of operations that change the data.

08. Which Db2 address space contains the Buffer Pools?

a) ssnmDIST

b) ssnmIRLM

c) ssnmDBM1

d) ssnmMSTR

09. Which two are valid trigger types?

(Choose Two)

a) BASIC

b) NATIVE

c) INTERNAL

d) ADVANCED

e) EXTERNAL

10. Which special register specifies the location name of the current server?

a) CURRENT NAME

b) CURRENT SERVER

c) CURRENT ADDRESS

d) CURRENT LOCATION

Answers:

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

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.