IBM C2090-612 - DB2 10 DBA for z/OS Exam
Page: 3 / 27
Total 133 questions
Question #11 (Topic: Topic 1)
The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The
following results are received: 1111 AAAA Which statement is true?
following results are received: 1111 AAAA Which statement is true?
A. Theencoding scheme of the table is EBCDIC.
B. The encoding scheme of the table is UNICODE.
C. This could never happen, this is an error and must be reported.
D. This is expected behavior and independent of the encoding scheme.
Answer: B
Question #12 (Topic: Topic 1)
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?
YES is altered toMEMBER 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).
Answer: D
Question #13 (Topic: Topic 1)
DB2 does not take system checkpoints in which circumstance?
A. During an application rollback.
B. At the end of a successful restart.
C. When switching from one active log data set to another.
D. When a specified number of log records are created or after a specified number of minutes, whichever occurs first.
Answer: A
Question #14 (Topic: Topic 1)
Which two of the following DB2 performance features will ignore clustering in favor of faster
insert performance? (Choose two.)
insert performance? (Choose two.)
A. Append
B. Inline LOBs
C. Member cluster
D. Volatile table
E. Includecolumns
Answer: A,C
Question #15 (Topic: Topic 1)
What IBM provided stored procedure will access DB2 real time statistics tables?
A. DSNAEXP
B. DSNAIMS
C. DSNACCOX
D. DSNLEUSR
Answer: C
