How can you find out which external and native stored procedures are active in the system? A. Use the -DIS PROCEDURE(*.*) command. B. Use the -DIS THREAD(*) TYPE(PROC) command. C. There is no WLM or DB2 command to obtain this…
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)
The following DDL statements are executed to create the following objects: CREATE TABLESPACE TS1 BUFFERPOOL BP0 IN DB1; CREATE TABLE USER1.TB1 ( COL1 INTEGER, COL2 VARCHAR(10) ) IN DB1.TS1; CREATE INDEX USER1.IX1 ON USER1.TB1 ( COL2 ) BUFFERPOOL BP0 COPY…
A unique index (IX1) currently exists on COL1, COL2 and COL3 of the table. There is a request to be able to have an index on these three columns and COL4 to achieve the optimal access path. The addition of…
If SEGSIZE 64 and MAXPARTITIONS 10 are specified in a CREATE TABLESPACE statement, what type of table space is created? A. LOB table space. B. Segmented table space. C. Range-partitioned table space. D. Partition-by-growth table space.
On what type of index would an ALTER INDEX ADD COLUMN be allowed? A. An XML index. B. An auxiliary index. C. A user defined catalog index. D. An index defined with BUSINESS_TIME WITHOUT OVERLAPS.
Which attribute(s) determine the absolute maximum number of partitions for a partition-by-growth table space? A. MAXPARTITIONS B. MAXPARTITIONS, DSSIZE C. MAXPARTITIONS, page size D. MAXPARTITIONS, DSSIZE, page size
What should be implemented in order to audit all the activity of the install SYSADM? A. DATA CAPTURE CHANGES should be set on all tables. B. A DB2 audit policy should be established, identifying the SYSADM ID to be audited.…
Which trace gives information about frequent log space shortages? A. Audit trace class(8) B. Statistics trace class(3) C. Accounting trace class(10) D. Performance trace class(4)
In the CFRM policy, what is the purpose of the PREFLIST? A. To identify the size of the structure. B. To identify all the DB2 members in the group. C. To identify the preferences for DB2 restart in the event…