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. What can someone with the system DBADM authority do?

a) Execute objects across the Db2 subsystem.

b) Grant or revoke privileges across the Db2 subsystem.

c) Manage objects in all databases across the Db2 subsystem.

d) Grant access to the data in the database(s).

02. Setting the following global host variable will have what effect on an application?

SET SYSIBMADM.MAX_LOCKS_PER_TABLESPACE = 100

a) When 100 locks are taken, lock escalation will occur.

b) When greater than 100 locks are taken the application fails.

c) When the application takes more than 100 locks Db2 will begin to release them at commit.

d) When greater than 100 locks are taken, the mode will be downgraded.

03. DSNZPARMs can set the DSSIZE and compression defaults. Which objects do these apply to?

a) Indexes

b) Implicitly created table spaces

c) XML and LOBS

d) All table space types

04. A DBA needs to delete an active log dataset from the BSDS without stopping Db2. The log dataset is currently not in use, but is reusable. Which option should the DBA use?

a) -SET LOG REMOVELOG command

b) DSNJU003 utility with the DELETE option

c) IDCAMS to delete the active log dataset

d) -FREE LOG command

05. In data modeling, how is logical data organized?

a) Table spaces

b) Tables and columns

c) Indexes and tables

d) Entities and attributes

06. Before migrating to Db2 13, what is one important step in the premigration process?

a) Ensure the fall back APAR is applied on Db2 12.

b) Ensure the fall back APAR is applied on Db2 13.

c) Verify the integrity of the catalog on Db2 12.

d) Verify the integrity of the catalog on Db2 13.

07. The list of IFCIDs that are shipped with Db2 is stored in which location?

a) Db2 catalog

b) SDSNSAMP

c) Db2 directory

d) SDSNMACS

08. How does a DBA maintain the accuracy of data in a system-maintained MQT?

a) Use INSERT, UPDATE, MERGE, TRUNCATE, or DELETE statements.

b) Use the LOAD utility.

c) Use the REORG utility.

d) Use the REFRESH statement.

09. Index usage tracking can be performed by monitoring which column in the following tables?

a) SPACEF column in SYSIBM.SYSINDEXES

b) COLCOUNT column in SYSIBM.SYSINDEXES

c) LASTUSED column in SYSIBM.SYSINDEXSPACESTATS

d) SPACEF column in SYSIBM.SYSINDEXPART

10. An application executes a non-atomic INSERT of multiple rows from host variable arrays. Which option can be used to check error and warning conditions for each individual insert?

a) SQLCA contains all information for each row separated by a token.

b) Execute GET DIAGNOSTICS to obtain the number of conditions and obtain each condition in a loop.

c) Use an extended indicator variable for each row, which will contain individual condition codes.

d) Call DSNTIAR with a host variable array to return the SQLCODE for each individual insert.

Answers:

Question: 01 Answer: c	Question: 02 Answer: a	Question: 03 Answer: b	Question: 04 Answer: a	Question: 05 Answer: d
Question: 06 Answer: a	Question: 07 Answer: b	Question: 08 Answer: d	Question: 09 Answer: c	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.