Register
Question 1
Which Db2 12 for z/OS table space type can hold exactly one table, supports growth-based partition allocation, and automatically adds partitions as the table grows?
Correct Answer:
Partition-by-Growth (PBG) UTS
Question 2
An application requires a partition-by-range Universal Table Space with up to 64 partitions. Which clause in CREATE TABLESPACE controls this upper bound?
Correct Answer:
MAXPARTITIONS 64
Question 3
In Db2 12 for z/OS, which feature allows a non-unique secondary index to be defined on a computed value such as UPPER(LASTNAME)?
Correct Answer:
Index on Expression
Question 4
Which Db2 12 column attribute generates unique numeric values automatically and can be defined as GENERATED ALWAYS or GENERATED BY DEFAULT?
Correct Answer:
Identity column
Question 5
A DBA needs a counter shared across multiple tables. Which Db2 object should be created?
Correct Answer:
A SEQUENCE object
Question 1
Exam overview

About this Exam

Prepare with the Db2 12 z OS DBA Practice Questions - IBM Certified Administrator - Db2 12 for z OS (C1000-078) Exam practice quiz. This question bank includes 100 questions covering table, data, utility, access, and subsystem. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

Db2 12 z OS DBA Practice Questions - IBM Certified Administrator - Db2 12 for z OS (C1000-078) Exam

This practice set contains 100 questions from the matching question bank and focuses on table, data, utility, access, and subsystem. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.
No fixed duration is currently configured for this quiz.
Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.
Yes. You can retake the practice test again as you continue studying during your available access period.
After your access is confirmed, you can continue into the complete practice exam from this quiz flow.
Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.
Keep studying

Related Questions

ISC2 Certified in Cybersecurity Practice Exam

0 min

Arizona CNA Certified Nursing Assistant Practice Exam

0 min

Certified Professional Public Buyer (CPPB) Practice Exam

0 min

Arizona Nursing Care Institution Administrators (NCIA) Practice Exam

0 min

Certified Specialist Business Intelligence (CSBI) Practice Test

0 min

Certified Specialist In Renal Nutrition (CSR) Practice Exam

0 min