C2090-612 Practice Questions and Answers Online

Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is correct?

A. NUMTCB parameter must be set to 1 for Java stored procedures.

B. NUMTCB parameter must be set to 1 for REXX stored procedures.

C. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures.

D. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities.

In order to retain an access path across a rebind which of the following commands could be used?

A. BIND PLAN

B. REBIND PACKAGE(PK1) REOPT(ONCE)

C. BIND PACKAGE (PK1) EXPLAIN(YES)

D. REBIND PACKAGE (PK1) PLANMGMT(BASIC)

Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?

A. The DB2 audit trace.

B. The DB2 statistics trace.

C. The DB2 connection trace.

D. The DB2 accounting trace.

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.

C. The DB2 authorization exit should be modified to convert the install SYSADM ID to another ID.

D. Nothing can be done, the install SYSADM has the highest authority and is not controlled or monitored.

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.

If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done?

A. Nothing because DB2 will control the values.

B. A unique index must be defined on the ROWID column.

C. An identity column must also be created to control uniqueness.

D. Extra space must be allocated for an overflow area in the table space.

Given the following statements have been run successfully and the buffer pools BP1 and BP2 both have the same page size: CREATE TABLESPACE TS1 IN DB1 DEFINE YES BUFFERPOOL BP1 MAXPARTITIONS 15 MEMBER CLUSTER ; CREATE TABLE TB1 (COL1 INT NOT NULL WITH DEFAULT) IN DB1.TS1 ; COMMIT ; ALTER TABLESPACE TS1 BUFFERPOOL BP2 MAXPARTITIONS 20 ; What is the next logical step in the sequence to CREATE an index IX1 on COL1 on TB1?

A. ALTER TABLESPACE TS1 MAXPARTITIONS 15;

B. COMMIT;

C. CREATE INDEX IX1 ON TB1 (COL1);

D. REORG TABLESPACE TS1;

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 COL4 will not support the uniqueness requirement of the index. In order to add this column to the index while still preserving the unique constraint of the first three columns, which option should be taken?

A. Add a new index on COL4.

B. Perform a ALTER INDEX IX1 ADD COLUMN (COL4).

C. Add a new UNIQUE index on COL1, COL2, COL3, COL4.

D. Perform an ALTER INDEX IX1 ADD INCLUDE COLUMN (COL4).

Which statement is true about table check constraints?

A. Only one constraint per column is allowed.

B. The LOAD utility cannot enforce the constraint.

C. A constraint placed on a table does not apply to a view defined on the table.

D. A row meets the requirement of the constraint if the condition evaluates to true or unknown.

Objects DB1.TS1 .... DB1.TS10 are in copy pending status. Which of the following actions removes the copy pending state AND creates an entry in SYSIBM.SYSCOPY?

A. Run the BACKUP SYSTEM utility.

B. Run the REPAIR SET NOCOPYPEND utility.

C. Run the COPY TABLESPACE utility with option FULL YES for each of the 10 table spaces.

D. Issue command -START DB(DB1) SP(TSx) ACCESS(FORCE) for each of the 10 table spaces where x = 1 - 10.

In order to communicate a DISPLAY DATABASE (DB1) SPACENAM (TS1) command execution from one DB2 member to another, which coupling facility structure is used?

A. GBP32

B. SCA

C. LOCK

D. GBP0

In which situation does adding a referential constraint place a table space containing data into check-pending status?

A. When a primary key is defined on a table with no unique index.

B. When a foreign key is defined on a table with the ENFORCED option.

C. When a foreign key is defined on a table and a corresponding primary key has not been defined.

D. When a foreign key is defined on a table with NOT ENFORCED option and a unique index has not been defined.

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

What is one of the first key steps in preparing to use the BACKUP SYSTEM utility?

A. Run the MODIFY RECOVERY utility.

B. Alter the BSDS to allow BACKUP SYSTEM.

C. Define one or more storage groups to a COPYPOOL.

D. Stop DB2 to enable DFSMShsm functionality to be used.

Which of the following statements is NOT correct?

A. UNLOAD with NOPAD improves performance.

B. Partition parallelism in UNLOAD is activated with STACK(YES) and UNIT(TAPE).

C. Unload will process cloned table with UNLOAD CLONE and CLONED YES on the LISTDEF.

D. Clone table allows replacing data without renames and rebinds to support online load replace.