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?
Database Design And Implementation
Question · Easy
An application requires a partition-by-range Universal Table Space with up to 64 partitions. Which clause in CREATE TABLESPACE controls this upper bound?
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)?
Question · Medium
Tech Exam Prep Podcast
Listen on Spotify
Podcast
Which Db2 12 column attribute generates unique numeric values automatically and can be defined as GENERATED ALWAYS or GENERATED BY DEFAULT?
A DBA needs a counter shared across multiple tables. Which Db2 object should be created?
Which type of temporal table preserves historical row versions every time the row is updated, with Db2 automatically copying the old image to a separate history table?
Which Db2 12 table organization stores rows in a fixed location based on a hash of the key, providing direct access without an index probe?
Question · Hard
Which Db2 12 ZPARM controls the default value of LOCKSIZE for table spaces created without an explicit LOCKSIZE specification?
Performance
Which Db2 12 utility reorganizes a table space and can also rebuild indexes and update inline statistics in a single execution?
Operation And Recovery
Which Db2 12 utility produces an image copy of a table space that can be used for subsequent RECOVER operations?
Which Db2 12 utility loads rows into a table from a sequential file and can perform inline statistics gathering with the STATISTICS keyword?
A DBA wants to extract rows from a table to a flat file in a controlled, recoverable manner with optional WHERE filtering. Which utility is appropriate?
Which Db2 12 command starts a single Db2 subsystem and brings it to ACTIVE status?
Which command displays the status, allocations, and connection counts for the Distributed Data Facility (DDF) address space?
Distributed Connectivity
Which protocol does DDF use to communicate with remote Db2 clients and servers?
Which Db2 12 mechanism allows administrators to enforce idle timeout, MAXDBAT-style limits, and monitoring filters by remote application name or product ID without changing applications?
Which DDF concept identifies the Db2 subsystem to remote clients and is referenced in CONNECT TO and three-part SQL names?
Which Db2 12 security feature lets a middleware server propagate the original end-user ID to Db2, with auditing tied to that user, while still using a single physical connection?
Security And Auditing
Which Db2 12 feature filters rows returned to a user based on a row-level rule defined with CREATE PERMISSION?
Which CREATE statement defines a column mask used by Db2 12 row and column access control?
Which RACF resource class controls connection-level access to a Db2 subsystem (for example, RRSAF, BATCH, or DIST attach)?
Which RACF resource class is used to externalize Db2 administrative authorities such as SYSADM, SYSCTRL, and DBADM via RACF profiles?
Which Db2 12 feature allows audit policies to be created as catalog objects with conditions, replacing per-table AUDIT clauses for many use cases?
Which Db2 12 statement is used to grant the SELECT privilege on a table to a user?
Which utility keyword instructs Db2 to capture access path information into the PLAN_TABLE for SQL statements being prepared?
Which Db2 12 buffer pool configuration is used by tables and indexes that must be resident in storage to minimize I/O for hot objects?
Which Db2 12 buffer pool attribute should be set so that the pages in the pool are fixed in real storage, eliminating paging by z/OS?
Which structure in a Db2 data sharing group caches pages and tracks inter-member dependencies for GBP-dependent objects?
An object in a data sharing group is currently opened by only a single member. What is its GBP dependency state?
Which Db2 12 cache stores prepared dynamic SQL statements so subsequent matching statements can avoid full prepare cost?
Which Db2 12 storage pool holds RID lists used by index ANDing, index ORing, list prefetch, and hybrid join?
Which Db2 12 facility records detailed performance and audit events identified by IFCIDs (for example, IFCID 3 for accounting and IFCID 4 for statistics)?
Which IBM tool provides real-time and historical performance monitoring of Db2 for z/OS using IFCID data, with online subsystem and thread views?
Db2 12 introduced continuous delivery via function levels. Which function level enabled new application features such as transparent archiving and continued tuning enhancements introduced after general availability?
Installation Migration And Upgrades
Which command activates a specific Db2 12 function level once all members in a data sharing group are at the prerequisite code level?
What is the purpose of the DSNTIJPM job in a Db2 12 migration scenario?
Which command displays the currently activated function level and the highest possible function level for a Db2 12 subsystem?
Which Db2 12 component provides the global locking service that supports both single-subsystem and data sharing concurrency control?
What is the role of the BSDS (Bootstrap Data Set) in Db2 12?
What is the recommended Db2 12 BSDS configuration for production?
Db2 active logs become full and are switched. Which utility offloads them to archive logs?
Which Db2 12 utility recovers a table space to its current state or to a prior point in time using image copies and the log?
Which Db2 12 utility produces a system-level backup of all Db2 data and logs that can be restored with RESTORE SYSTEM?
A storage-system FlashCopy is requested with the COPY utility using the FLASHCOPY YES option. What is the primary benefit?
What is the primary use of a CONDITIONAL RESTART control record (CRCR) in Db2 12?
Which command stops a Db2 subsystem cleanly, allowing in-flight units of work to commit or roll back?
Which utility updates Db2 catalog statistics that the optimizer uses to choose access paths?
Loading more…