IBM DB2 11 DBA for z/OS - C2090-312 Exam Practice Test

A. The index has now a status of RECP.

B. The index has now a status of REFP.

C. The index has now a status of RBDP.

D. The index has now a status of CHKP.

A. The size of individual rows in the table vary greatly.

B. DB2 uses sequential lookups to access data in the table.

C. DB2 uses range scans to access rows in the table.

D. At least 20 rows fit on a data page.

A. A one-to-one relationship.

B. A many-to-many relationship.

C. A one-to-many relationship.

D. A many-to-one relationship.

A. Rows from an image copy after the table has been dropped.

B. Rows from a sequential image copy created by the COPYTOCOPY utility.

C. Index entries from an index image copy.

D. Rows from an image copy after columns have been dropped.

A. A trigger can use global variables but cannot change their contents.

B. A trigger can use global variables and change their contents.

C. A trigger cannot use global variables and cannot change their contents.

D. A trigger cannot use global variables but can change their contents.

A. It is possible to define the XML column with an INLINEJ.ENGTH.

B. Data stored in XML columns cannot be indexed.

C. You can partially UPDATE, DELETE from, and INSERT into an XML document.

D. If you want to change an existing XML document, you have to replace the whole document in the XML column.

A. CONDBAT

B. IDTHTOIN

C. MAXCONQN

D. MAXDBAT