What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the cache?
A. KEEPDYNAMIC(YES) and CACHEDYN=YES
B. KEEPDYNAMIC(NO) and CACHEDYN=NO
C. KEEPDYNAMIC(NO) and REOPT(ALWAYS)
D. KEEPDYNAMIC(YES) and REOPT(ALWAYS)
Which authority level allows a user to run utilities that change the data in an application database?
A. DBCTRL
B. SYSOPR
C. DBMAINT
D. INSTALL SYSOPR
Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?
A. ALTER TABLE TB1 AUDIT CHANGES;
B. ALTER TABLE TB1 ADD COLUMN COLC DATE;
C. ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;
D. ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS SECURITY LABEL;
When defining a foreign key on a table, which statement is true?
A. It is not mandatory to have an index on the foreign key columns but it can help to avoid locking problems.
B. There is no need to define an index on the foreign key columns as DB2 cannot use an index for foreign key checking.
C. It is not mandatory to have an index on the foreign key columns but it can help performance when you insert rows into this table.
D. You must define an index on the foreign key columns where the index columns are the same as the foreign key columns to guarantee uniqueness of the foreign key.
You have to design a numeric column, which is also the primary key. The column should cover large (i.e., 123456789012345678) numbers. Which column data definition covers the requirements?
A. BIGINT
B. INTEGER
C. DECFLOAT (34)
D. DECIMAL (31,18)
A table space is in AREO*. What does this status mean?
A. A full image copy of the table space must be taken.
B. The table space should be reorganized for optimal performance.
C. A START command must be issued to remove it from the pending status.
D. The table space must be reorganized to materialize all pending changes.
When specifying "A" for the acceptance option in the column SECURITY_IN in the SYSIBM.LUNAMES catalog table, which statement is correct?
A. An inbound ID is subject to translation.
B. A request does not need an authentication token.
C. With this option, VTAM cannot be defined with SECACPT=ALREADYV.
D. For outbound requests, the encrypted password is extracted from RACF.
A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?
A. The data is only stored in the auxiliary table.
B. The data is only stored in the base table.
C. The complete data is stored both in auxiliary and in base table.
D. The first part of the data is stored in the base table and second part is stored in the auxiliary table.
Which of the following types of table spaces allow multiple tables?
A. Segmented
B. LOB table space
C. Partition-by-range
D. Partition-by-growth
Which of the following utilities is NOT relevant for health checking the DB2 V10 catalog or directory in new function mode?
A. CHECK LOB
B. CHECK INDEX
C. DSN1COPY
D. DSN1CHKR
