今天下單、今天開始讀。KaoGuTi 的 C2090-612 題庫在付款後一分鐘內寄到你的信箱，134 道練習題即刻到手，2026 年的考試準備就從現在開始。

IBM C2090-612 考試概覽:

認證廠商:	IBM
考試名稱:	IBM 認證資料庫管理員 - DB2 10 for z/OS
考試代碼:	000-612 / C2090-612
實際考試題數:	67
考試費用:	200 USD
相關認證:	IBM 認證資料庫管理員 - DB2 12 for z/OS IBM 認證資料庫管理員 - DB2 11 for z/OS
考試形式:	複選題, 單選題
及格分數:	60%
證照有效期限:	3 年
支援語言:	English
考試時間:	90 分鐘
推薦課程:	IBM 教育訓練 - DB2 10 for z/OS 管理
考試報名:	Pearson VUE 報名 IBM 認證入口網站
範例考題:
考試方式:	於 Pearson VUE 考試中心實體監考，或線上監考
必備條件:	建議具備 1–2 年 DB2 10 for z/OS 實務管理經驗；無強制性先修考試
官方大綱網址:	https://www.ibm.com/certify/tests/obj000-612.shtml

IBM C2090-612 考試大綱主題:

IBM DB2 10 DBA for z/OS 考試常見問題解答

最新的 DB2 C2090-612 免費考試真題：

問題 #1

Which statement is NOT true?

A. DSNACCOX can be used for collecting data for table space and index space for getting recommendations when to run REORG, RUNSTATS or COPY.
B. 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.
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.

問題 #2

To monitor the storage used above and below the 2GB bar, what must occur?

A. Start an audit class 3 trace.
B. Start accounting class 7 & 8 traces.
C. Start a monitor class 1 & 2 trace.
D. Start a statistics class 1 trace.

問題 #3

In a data sharing environment, how is the LRSN value created?

A. It is selected from the DB2 catalog.
B. It is derived fromcombining RBAs from multiple members.
C. It is derived from the sysplex timer (store clock).
D. It is generated from a sequence object.

問題 #4

Given the following statements have been run successfully and the buffer pools BP1 and BP2 both have the same page size: CREATE TABLESPACE TS1 IN DB1 DEFINE YES BUFFERPOOL BP1 MAXPARTITIONS 15 MEMBER CLUSTER ; CREATETABLE TB1 (COL1 INT NOT NULL WITH DEFAULT) IN DB1.TS1 ; COMMIT ; ALTER TABLESPACE TS1 BUFFERPOOL BP2 MAXPARTITIONS 20 ; What is the next logical step in the sequence to CREATE an index IX1 on COL1 on TB1?

A. COMMIT;
B. ALTER TABLESPACE TS1
MAXPARTITIONS 15;
C. REORG TABLESPACE TS1;
D. CREATE INDEX IX1 ON TB1
(COL1);

問題 #5

If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done?

A. A unique index must be defined on the ROWID column.
B. Nothing because DB2 will control the values.
C. Extra space must be allocated for an overflow area in the table space.
D. An identity column must also be created to control uniqueness.

問題與答案：