IBM Db2 13 for z/OS Database Administrator Associate (C1000-184) 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 - Associate exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the C1000-184 certification test. To get familiar with real exam environment, we suggest you try our Sample IBM Db2 13 for z/OS Database Administrator Associate 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 - Associate certification exam.

These sample questions are simple and basic questions that represent likeness to the real IBM C1000-184 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 Associate 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-184 Sample Questions:

01. When defining a table with a large numeric column (i.e. 123456789012345678), which is also the primary key, what data type would be the best option?

a) DECFLOAT(34)

b) INTEGER

c) DECIMAL(31,18)

d) BIGINT

02. A DSN command can be utilized to perform which operation?

a) Start Db2.

b) Bind a query

c) Submit a utility job.

d) Alter a buffer pool.

03. Which coupling facility structure is responsible for communicating Db2 status information to each member of the data sharing group?

a) GBP

b) Lock

c) SCA

d) WLM

04. A performance analyst wants to identify inefficient SQL statements causing excessive table scans within a production subsystem. Which Db2 feature should be reviewed first?

a) EXPLAIN output

b) Buffer pool startup parameters

c) Archive logging configuration

d) Utility job schedules

05. Which two lock combinations are compatible?

a) Share lock and exclusive lock

b) Share lock and share lock

c) Exclusive lock and exclusive lock

d) Update lock and update lock

e) Share lock and update lock

06. What is the purpose of a Db2 Monitor trace?

a) It can be used to enable attached monitor programs to access Db2 trace data through calls to the instrumentation facility interface.

b) It can be used to enable the ACCUMACC subsystem parameter for accounting data aggregation.

c) It can be used to ensure that data access is allowed only for authorized purposes.

d) It is used the automatically start and stop Db2.

07. When inserting a new row into a child table with an enforced relationship to a parent table, what happens when the foreign key data does not match the parent key?

a) The child row is not added and a warning is returned.

b) The child row is added to the parent table.

c) The child row is added but not yet available for readers.

d) The child row is not added and an error is returned.

08. What is the major difference between a correlated and non-correlated subquery execution within a WHERE clause of a SELECT statement?

a) Results from a correlated subquery in a WHERE clause can be returned in the result of the outer SELECT.

b) A non-correlated subquery in a WHERE clause executes only once, while a correlated subquery can execute many times.

c) Results from a non-correlated subquery in a WHERE clause can be returned in the result of the outer SELECT.

d) A correlated subquery in a WHERE clause executes only once, while a non-correlated subquery can execute many times.

09. Which of the following is true regarding the use of RPN (Relative Page Numbering) on a table space?

a) It is implemented by specifying PAGENUM ABSOLUTE on the CREATE TABLESPACE statement.

b) Different partitions of the same table must have the same size limits.

c) DSSIZE can be increased for a partition with an ALTER, without requiring a REORG.

d) RPN is valid for all partitioned table space types.

10. Where is the information about system level backups stored?

a) BSDS

b) Checkpoint

c) Db2 Log

d) SYSCOPY

Answers:

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

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