Free IBM 000-612 Exam Dumps Questions & Answers

Which ALTER TABLE statement will generate a new table space version?

• A.ALTER TABLE ... ADD COLUMN COL2 ...
• B.ALTER TABLE ... ADD PARTITION ...
• C.ALTER TABLE ... DATA CAPTURE CHANGES ...
• D.Altering an already existing VARCHAR column on the table to shorten its maximum length.

Which attribute(s) determine the absolute maximum number of partitions for a partition-by- growth table space?

• A.MAXPARTITIONS, DSSIZE
• B.MAXPARTITIONS, page size
• C.MAXPARTITIONS, DSSIZE, page size
• D.MAXPARTITIONS

Which statement is NOT true?

• A.REORG of index space could be eliminated because the list prefetch of index leaf pages in DB2 V10 is based on non-leaf page information.
• B.DSNACCOX can be used for collecting data for table space and index space for getting recommendations when to run REORG, RUNSTATS or COPY.
• C.REORG with SHRLEVEL CHANGE would automatically detect which threads need to be canceled before switch phase.
• D.REORG table space to materialize pending definition changes for a table space.

What is the DSNZPARM thatdetermines the maximum amount of temporary storage in the work file data base for a single user at any given time?

• A.MAXRBLK
• B.MAXKEEPD
• C.MAXTEMPS
• D.MAXDBAT

Which of the following statements is NOT correct?

• A.UNLOAD with NOPAD improves performance.
• B.Clone table allows replacing data without renames and rebinds to support online load replace.
• C.Partition parallelism in UNLOAD is activated with STACK(YES) and UNIT(TAPE).
• D.Unload will process cloned table with UNLOAD CLONE and CLONED YES on the LISTDEF.