Which type of table space is the only one supported for new table creation in Db2 13 for z/OS, with non-UTS classic types deprecated?
Database Design And Implementation
Question · Easy
What is the primary advantage of PBR-RPN (Partition By Range with Relative Page Numbering) over classic PBR with Absolute Page Numbering?
In Db2 13, what is the default value of the PAGESET_PAGENUM ZPARM for new PBR table spaces?
Tech Exam Prep Podcast
Listen on Spotify
Podcast
Which Db2 13 function level enables online conversion of a PBG table space to a PBR table space using ALTER PARTITIONING TO PARTITION BY RANGE?
Question · Medium
An administrator wants to create a table space that automatically adds partitions when the existing ones fill up. Which UTS variant should be used?
Which clause of CREATE INDEX defines an index whose key columns include all partitioning columns of the underlying table, allowing it to be used for partition-level utilities?
In Db2 13, what happens to RID (Record Identifier) size when a PBR table space is converted from APN to RPN?
Which CREATE TABLE option enables row-level security through a security label column that is checked against MLS RACF labels?
Security And Auditing
Question · Hard
Which Db2 13 feature allows defining triggers that may contain multiple SQL statements with control logic and parameter signatures, similar to procedures?
What does CREATE TABLE ... WITH SYSTEM VERSIONING enable for a table?
An administrator needs to add a column to a non-key partitioning column without invalidating dependent packages. Which technique should be used in Db2 13?
Which catalog table records pending DDL changes that must be materialized by REORG?
Which keyword in CREATE TABLE allows the table to use a sequence-like value automatically generated for a numeric column?
Which option of CREATE INDEX is required to make an index able to support index-only access for additional non-key columns?
What is the maximum DSSIZE per partition supported in a PBR-RPN table space in Db2 13?
An LOB column stores objects up to 4 GB. Which auxiliary structure does Db2 require for an LOB column?
Which Db2 feature lets multiple tables share a hash space in memory to avoid sort overhead during table joins, and was deprecated before Db2 13?
Which type of materialized query table (MQT) lets Db2 refresh its content automatically when underlying base tables change?
Which view in the SQL DI (SQL Data Insights) feature is created to expose a vector embedding for an enabled table?
Which COMPRESS option, available for indexes, reduces leaf-page storage and is supported on UTS table-space data and on indexes in Db2 13?
Which utility reorganizes a table space, rebuilds clustering, and can run with SHRLEVEL CHANGE to allow read/write during most of the process?
Operation And Recovery
Which Db2 utility collects statistics used by the optimizer for access path selection?
Which Db2 13 feature lets RUNSTATS automatically request profile-based statistics that match what the dynamic statement cache and prior queries actually used?
Which utility produces an image copy that can be used as the recovery base by the RECOVER utility?
Which COPY option captures a data-set-level copy almost instantly using DFSMSdss and z/OS storage hardware?
Which RECOVER option restores a table space to a specific log point identified by a quiesce or timestamp?
Which command stops a Db2 subsystem normally so that all current work completes and no new connections are accepted?
Which utility loads data into a table from sequential input, optionally with KEEPDICTIONARY and PRESORTED options?
Which option of LOAD allows a table to remain available for read and update while data is being loaded?
Which Db2 13 feature lets the DBA stop log capture for an active log data set on a running subsystem so the data set can be removed?
Which Db2 13 catalog table introduced at FL501 records the history of utility executions, similar to SYSCOPY but with broader detail?
Which utility output maintains data on real-time statistics so that the optimizer and DBAs can see current activity without running RUNSTATS first?
Which command displays current open units of recovery (URs) and their RBA values, useful for recovery and concurrency analysis?
Which option of REORG enables a logical reorganization of all logical partitions of a partitioned index together?
An administrator must check that all referential integrity is consistent after a LOAD with ENFORCE NO. Which utility verifies and resets the constraint-checking flag?
Which Db2 utility merges incremental image copies with the most recent full image copy to produce a new full image copy?
Which Db2 13 enhancement to REORG reduces log records written during the SWITCH phase by streamlining how page mapping changes are recorded?
Which BACKUP SYSTEM type produces a recoverable copy of all data and the catalog at a single consistent point using DFSMShsm?
Which trace class is most commonly used to capture accounting data for chargeback and performance analysis without the overhead of statement-level traces?
Which Db2 utility quiesces specified table spaces, recording a recovery point in SYSIBM.SYSCOPY?
Which authorization is required to issue Db2 commands such as -START DB2 and -STOP DB2?
Which Db2 administrative authority allows reading and updating user data across all databases without the ability to grant authorities or alter security objects?
Which authority is required to create and own audit policies in SYSIBM.SYSAUDITPOLICIES?
Which command activates an audit policy named PAYROLL_AUDIT for trace and capture?
Which Db2 row access control construct implements column masking that returns a masked value (for example, NULL or substring) to unauthorized users?
Which mechanism lets external Db2 connections authenticate using RACF passticket or user/password verified by RACF?
Which feature transparently encrypts Db2 data sets at rest using policy-based key management with z/OS Data Set Encryption?
Loading more…