Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?
A. To prunethe contents of a staging table.
B. To prune the contents of a synopsis table.
C. To prune the contents of a materialized query table (MQT).
D. To prune the contents of a declared global temporary table.
Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?
A. UPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC
B. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES
C. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90
D. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC
What is the result of the following scenario?
A. The row is updated to (2, NULL)
B. The row is updated to (2, 110.00)
C. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed
D. The CREATE TRIGGER statement will fail because amt is defined as NOT NULL
Which security mechanism is responsible for verifying that users are indeed who the claim to be?
A. Authentication
B. Roles and privileges
C. Mandatory access control
D. Discretionary access control
When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?
A. The page size is too small.
B. The extent size is too small.
C. Low cardinality of the dimension(s) chosen.
D. High cardinality of the dimension(s) chosen.
How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?
A. Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.
B. Set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE DATABASECONFIGURATION command or the db2CfgSet API.
C. Set the sortheap or the sheapthres_shr configuration parameters to AUTOMATIC using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API with sheapthres set to at least 4K.
D. Use AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or the ALTER BUFFERPOOL statement after making sure that at least one entry is present in SYSCAT.BUFFERPOOLDBPARTITIONS.
Which of the following statements is TRUE?
A. REORGCHK automatically runstables reorganization.
B. REORGCHK uses only current table and index statistics.
C. REORGCHK can only be used for user tables, not for system tables.
D. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.
When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)
A. The routine cannot contain comments.
B. The routine must return either an integer or a null.
C. The routine must be cross-compatible with Oracle PL/SQL syntax rules.
D. The routine cannot contain argument lists or variable arguments (varargs).
E. The routine must be generated with IBM Database Conversion Workbench (DCW).
Which statement about label-based access control (LBAC) is TRUE?
A. LBAC protection can be applied to a nickname
B. LBAC cannot be used to restrict access to a staging table
C. LBAC cannot be used to restrict access to data of columns and rows in the same table
D. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
A. CONNECT TO mydbPRUNE HISTORY TO /outdir
B. db2trc on –db mydb –m “backup,load”run the desired operationsdb2tc dump db2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off
C. BACKUP DATABASE mydb NO TABLESPACE TO /outdir
D. db2setDB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump
