IBM C2090-612 - DB2 10 DBA for z/OS Exam
Page: 2 / 27
Total 133 questions
Question #6 (Topic: Topic 1)
In determining whether a REORG on an index space would improve performance, which
two of the following columns would NOT be needed? (Choose two.)
two of the following columns would NOT be needed? (Choose two.)
A. Column CLUSTERING in SYSIBM.SYSINDEXES
B. Column LEAFDIST in SYSIBM.SYSINDEXPART
C. Column CLUSTERRATIOF in SYSIBM.SYSINDEXES
D. Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS
E. Columns LEAFNEAR and LEAFFAR in SYSIBM.SYSINDEXPART
Answer: A,D
Question #7 (Topic: Topic 1)
If SEGSIZE 64 and MAXPARTITIONS 10 are specified in a CREATE TABLESPACE
statement, what type of table space is created?
statement, what type of table space is created?
A. LOB table space.
B. Segmented table space.
C. Range-partitioned tablespace.
D. Partition-by-growth table space.
Answer: D
Question #8 (Topic: Topic 1)
Which authoritylevel allows a user to run utilities that change the data in an application
database?
database?
A. DBCTRL
B. SYSOPR
C. DBMAINT
D. INSTALL SYSOPR
Answer: A
Question #9 (Topic: Topic 1)
What would be a reason for altering the clustering index of a table?
A. To increase free space.
B. Because the clusteringindex has to match the primary index.
C. To choose a clustering index to favor batch sequential processing.
D. To choose a clustering index to promote sequential inserts at the end of the table space.
Answer: C
Question #10 (Topic: Topic 1)
Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?
A. Does not apply tothreads that were defined with RELEASE(COMMIT).
B. Does not apply to threads that were defined with RELEASE(DEALLOCATE).
C. Applies to both RELEASE(COMMIT) and RELEASE(DEALLOCATE) at the next COMMIT point.
D. Applies to RELEASE(COMMIT) at the next COMMIT point and to RELEASE(DEALLOCATE) at thread end.
Answer: C
