重考一次 C2090-600，等於再付一次報名費，還要再花好幾週重新準備。與其承擔重考成本，不如先用 KaoGuTi 的 60 道練習題，把 IBM DB2 11.1 DBA for LUW 的每個領域練熟再上場。

IBM C2090-600 考試概覽:

認證廠商:	IBM
考試名稱:	IBM DB2 11.1 DBA for LUW
考試代碼:	C2090-600
考試時間:	90 分鐘
及格分數:	60題中需答對38題（約63%）
證照有效期限:	本考試及其相關認證已**下架**（於2023年3月31日停止適用）
實際考試題數:	60
考試費用:	依地區而定（以IBM官方／Pearson VUE公告價格為準）
相關認證:	IBM Certified Database Associate - DB2 11.1 Fundamentals for LUW IBM Certified Database Administrator - DB2 11.1 for LUW Credential
支援語言:	English
考試形式:	選擇題
範例考題:
考試方式:	由IBM授權的考試機構辦理（例如Pearson VUE）
必備條件:	無正式先修條件，但建議具備相關DB2資料庫管理經驗
官方大綱網址:	https://www.ibm.com/training/certification/ibm-certified-database-administrator-db2-111-for-linux-unix-and-windows-08002109

IBM C2090-600 考試大綱主題:

C2090-600 認證考試問與答

最新的 IBM Certified Database Administrator C2090-600 免費考試真題：

問題 #1

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.
Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

A. REORG TABLE sales INPLACE; REORG INDEXES ALL FOR TABLE sales; RUNSTATS ON TABLE sales AND IN DEXES ALL;
B. RUNSTATS ON TABLE sales IN PLACE AND INDEXES ALL;
C. REORG TABLE sales AND INDEXES ALL; RUNSTATS ON TABLE sales AND INDEXES ALL;
D. RUNSTATS ON TABLE sales AND INDEXES ALL; REORGCHK ON TABLE sales;

問題 #2

What does dsmtop use to gather metrics?

A. monitoring table functions
B. db2dart
C. the system catalog
D. db2pd

問題 #3

Given the following:

What will be the result of the following SQL statement?
INSERT INTO v3 (col1) values (30);

A. The insert will succeed as there is no WITH CHECK OPTION on view V3.
B. The insert will succeed as it passes validation.
C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.
D. The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.

問題 #4

What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?

A. It does not require additional temporary disk space
B. It does not acquire locks on the table
C. It enables the user to control when the table will be offline
D. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments

問題 #5

You suspect there is a communications issue between a member and a cluster caching facility (CF) in a
DB2 pureScale instance. Which command will provide diagnostic information that can be used to confirm your suspicions?

A. db2cluster -cm -list -alert
B. db2cluster -verify
C. db2cluster -cm -verify -resource
D. db2cluster -verify -configuration

問題與答案：