IBM 000-612 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 000-612
Exam Name/Title: IBM Certified Database Administrator - DB2 10 for z/OS
Certification Provider: IBM
Corresponding Certification: DB2

Exam Questions: 134
Updated On: May 29, 2026

Question #17

A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?

A. The complete data is storedboth in auxiliary and in base table.

B. The data is only stored in the base table.

C. The data is only stored in the auxiliary table.

D. The first part of the data is stored in the base table and second part is stored in the auxiliary table.

Discussion 0

Correct Answer: B Vote an answer

Question #18

When planning for backup/recovery (including disaster recovery), which statement is correct?

A. When you remote copy everything (PPRC, XRC) there is no need to take DB2 image copies anymore.

B. As data is shared in adata sharing group, disaster recovery in a data sharing environment is identical to a non-data sharing environment.

C. When you want to create a consistent backup point, you must use the -SET LOG SUSPEND command to freeze all activity, and then take your backups with whatever technology you prefer.

D. System level backups (BACKUP SYSTEM) can be used for both system wide restore on a remote site, as well as the recovery of individual objects locally.

Discussion 0

Correct Answer: D Vote an answer

Question #19

For monitoring space growth over time, which statistics should NOT be considered?

A. SYSIBM.SYSTABLEPART
CARDF, SPACEF
SYSIBM.SYSINDEXPART
CARDF, SPACEF

B. SYSIBM.SYSTABLESPACE
DSSIZE, AVGROWLEN
SYSIBM.SYSINDEXES
PIECESIZE, AVGKEYLEN

C. SYSIBM.SYSTABLESPACESTATS
SPACE
SYSIBM.SYSINDEXSPACESTATS
SPACE

D. SYSIBM.SYSTABLEPART_HIST
CARDF, SPACEF
SYSIBM.SYSINDEXPART_HIST
CARDF, SPACEF

Discussion 0

Correct Answer: B Vote an answer

Question #20

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

A. CHECK INDEX

B. CHECKLOB

C. DSN1CHKR

D. DSN1COPY

Discussion 0

Correct Answer: C Vote an answer

Question #21

When defining a foreign key on a table, which statement is true?

A. You must define an index on the foreign key columns where the index columns are the same as the foreign key columns to guarantee uniqueness of the foreign key.

B. It is not mandatory to have anindex on the foreign key columns but it can help to avoid locking problems.

C. There is no need to define an index on the foreign key columns as DB2 cannot use an index for foreign key checking.

D. It is not mandatory to have an index on the foreign key columns but it can help performance when you insert rows into this table.

Discussion 0

Correct Answer: B Vote an answer

Question #22

Why does the following DDL command fail? CREATE INDEX X1 ON T1 (COL1, COL2, COL3, BUSINESS_TIME WITHOUT_OVERLAPS);

A. The index must be partitioned.

B. The index must use page size > 4K.

C. The index must be defined as CLUSTER.

D. The index must be defined as UNIQUE.

Discussion 0

Correct Answer: D Vote an answer

Question #23

What should be implemented in order to audit all the activity of the install SYSADM?

A. Nothing can be done, the install SYSADM has the highest authority and is not controlled or monitored.

B. DATA CAPTURE CHANGES should be set on all tables.

C. The DB2 authorization exit should be modified to convert the install SYSADM ID to another ID.

D. A DB2 audit policy should be established, identifying the SYSADM ID to be audited.

Discussion 0

Correct Answer: D Vote an answer

Question #24

What is a consideration when specifying DATA CAPTURE CHANGES?

A. To minimize logging, specify NOT LOGGED when DATA CAPTURE CHANGES is specified.

B. Can be specified for capturing changes to an XML object.

C. REFRESH TABLE statement is not allowed with a table defined with DATA CAPTURE CHANGES.

D. You cannot turn on DATA CAPTURE CHANGES if the table space is in
advisoryREORG-pending.

Discussion 0

Correct Answer: D Vote an answer

Download Free IBM 000-612 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM 000-612 exam.