The data of a critical table space seems inconsistent. It is suspected that someone has accidentally issued a DB2 command to start the object with MODE (FORCE). Where can this be verified? A. In the DSN1PRNT job output of the…
Which statement is true if a table space is created using the "FOR UPDATE nn" (where nn is a number) clause? A. The first nn UPDATE operation(s) will use an indirect reference. B. Only the first nn UPDATE operation(s) on…
Index versions are created when certain schema changes are committed. Which schema change results in a new index version being created? A. Issue the ALTER INDEX REGENERATE statement. B. Use the ALTER INDEX statement to add a column to an…
Arrays are based on a built-in data type. On which built-in data type can an array NOT be based? A. XML B. CLOB C. DBCLOB D. VARBINARY
When we use multilevel-security using a security label column, which sentence is true? A. A unique constraint is allowed on a security label column. B. A check constraint is not allowed on a security label column. C. A referential constraint…
Which type of stored procedures do NOT require a WLM-managed stored procedure address space? A. External stored procedures. B. Native SQL stored procedure. C. External SQL stored procedures. D. DB2 supplied stored procedures.
You must be able to process recoveries for DB2 objects to any point in time between now and two weeks ago. What is the recommended amount of recovery data needed? A. One set of SHRLEVEL(CHANGE) full image copies every two…
Which statement is true? A. Unicode and EBCDIC have a different collating sequence. B. The collating sequence for ASCII and EBCDIC is identical. C. The collating sequence for Unicode and EBCDIC is identical. D. If you use BETWEEN in your…
Which statement is true regarding table-controlled partitioned table spaces without a MAXVALUE specified? A. If the partitioning key is ascending, DB2 prevents the INSERT of a row with a null value for the key column. B. If the partitioning key…
DB2 AUDIT policies are defined by inserting rows into what DB2 Catalog table? A. SYSIBM.SYSDBAUTH B. SYSIBM.SYSAUTOALERTS C. SYSIBM.SYSAUDITPOLICIES D. SYSIBM.SYSTABLESPROFILES