C2090-612 by IBM Actual Free Exam Questions And Answers

Question 1

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

A. TheDB2 audit trace.

B. The DB2 accounting trace.

C. The DB2 connection trace.

D. The DB2 statistics trace.

Discussion 0

Correct Answer: D Vote an answer

Question 2

If security administration isseparated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts?

A. SYSADM

B. INSTALL SYSOPR

C. DBADM

D. SECADM

Discussion 0

Correct Answer: D Vote an answer

Question 3

What IBM provided stored procedure will access DB2 real time statistics tables?

A. DSNAIMS

B. DSNLEUSR

C. DSNACCOX

D. DSNAEXP

Discussion 0

Correct Answer: C Vote an answer

Question 4

When is changing an index from non-clustering to clustering NOT allowed?

A. If the data is not ordered by the new clustering index.

B. If the new clustering index OBID is greater than the old clustering index OBID.

C. If the new clustering index is for a table that uses hash organization.

D. If the table space isdefined as member cluster.

Discussion 0

Correct Answer: C Vote an answer

Question 5

Poorly tuned memory can affect application performance, such as having sequential prefetch turned off. Which statistic should you monitor from the statistics report to be sure this is not occurring?

A. BUFF.UPDATES/PAGESWRITTEN

B. PREF.DISABLED-NO READ ENG

C. PREF.DISABLED-NO BUFFER

D. PAGES WRITTEN PER WRITE I/O

Discussion 0

Correct Answer: C Vote an answer

Question 6

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

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

B. DB2 applies the changes immediately.

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

D. DB2 does not allow the command.

Discussion 0

Correct Answer: C Vote an answer

Question 7

On what type of index would an ALTER INDEX ADD COLUMN be allowed?

A. An XML index.

B. An index defined with BUSINESS_TIME WITHOUT OVERLAPS.

C. An auxiliary index.

D. A user defined catalog index.

Discussion 0

Correct Answer: D Vote an answer

Question 8

Whichstatement is true about table check constraints?

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

B. Only one constraint per column is allowed.

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

D. The LOAD utility cannot enforce the constraint.

Discussion 0

Correct Answer: A Vote an answer

Question 9

Which of the following utilities is NOT relevant for health checking the DB2 V10 catalog or directory in new function mode?

A. CHECKLOB

B. DSN1COPY

C. DSN1CHKR

D. CHECK INDEX

Discussion 0

Correct Answer: C Vote an answer

Question 10

Which DB2 performance feature is designed specificallyto reduce the number of indexes that need to be created?

A. Direct row access.

B. Inline LOBs.

C. Hash row access.

D. Include columns.

Discussion 0

Correct Answer: D Vote an answer

IBM DB2 10 DBA for z/OS - C2090-612 Exam Practice Test

Contact Us

Useful Links

Latest Updated