C2090-612 Online Practice Questions and Answers

What is a consideration when specifying DATA CAPTURE CHANGES?

A. Can be specified for capturing changes to an XML object.

B. To minimize logging, specify NOT LOGGED when DATA CAPTURE CHANGES is specified.

C. REFRESH TABLE statement is not allowed with a table defined with DATA CAPTURE CHANGES.

D. You cannot turn on DATA CAPTURE CHANGES if the table space is in advisory REORG- pending.

When converting a multiple table segmented table space to partition-by-growth table spaces, which statement is correct?

A. DSMAX may have to be increased.

B. Storage requirements for EDMDBDC will decrease.

C. Storage requirements for some applications will increase.

D. The dynamic statement cache should be increased to handle the additional SQL statements.

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.

When a table space defined as both partitioned-by-growth (PBG) and MEMBER CLUSTER YES is altered to MEMBER CLUSTER NO by the ALTER TABLESPACE command. Which statement is correct?

A. DB2 does not allow the command.

B. DB2 applies the changes immediately.

C. DB2 allows the command only if the table is empty.

D. DB2 places the table space in AREOR (Advisory Reorg).

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)

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.

Which DSNZPARM parameter controls the number of locks that may be acquired on a table space?

A. NUMLKUS

B. MAXUSRS

C. NUMLKTS

D. MXDTCACH

Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3 CLOB(1K)) ; How many VSAM clusters will DB2 create?

A. 1

B. 4

C. 5

D. 6

A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur?

A. Specify the column names to be hashed.

B. Create a unique index on the hash columns.

C. Create a clustering index on the hash columns.

D. Create a unique clustering index on the hash columns.

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