IBM C2090-546 考試概覽:

認證廠商:	IBM
考試名稱:	DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade 升級考試
考試代碼:	000-546 / C2090-546
考試費用:	$200 USD
考試形式:	選擇題
實際考試題數:	39
支援語言:	Japanese, English
及格分數:	55%
考試時間:	90 分鐘
相關認證:	IBM Certified Database Administrator - DB2 9.5 for Linux, UNIX, and Windows
證照有效期限:	3 年
推薦課程:	DB2 9.7 文件庫 IBM DB2 9.7 新功能：給資深 DBA 的課程
考試報名:	IBM 認證頁面 Pearson VUE 報名
範例考題:	IBM C2090-546 範例考題
考試方式:	線上監考或至授權 Pearson VUE 考試中心應考
必備條件:	持有有效之 IBM Certified DBA - DB2 9.1 or 9.5 for Linux, UNIX, and Windows 認證
官方大綱網址:	https://www.ibm.com/training/certification

IBM C2090-546 考試大綱主題:

章節	權重	目標
主題 1: XML 與進階功能	5%	- XML 儲存與索引 - XQuery 與 XML 更新
主題 2: 實體設計與儲存	22.5%	- 資料表空間與容器 - 索引設計與最佳化 - 資料分割與壓縮
主題 3: 備份、復原與高可用性	15%	- 還原與向前復原 - 線上與離線備份策略 - HADR 與日誌功能強化
主題 4: 效能與調校	17.5%	- SQL 最佳化與統計資料 - 工作負載管理 - 記憶體與組態參數
主題 5: 監控與問題判斷	7.5%	- 鎖定與並行分析 - 診斷日誌分析 - 事件監控器與快照
主題 6: 安全與授權	12.5%	- 角色型存取控制 - 加密與稽核 - 驗證與授權模型
主題 7: 安裝、移轉與升級	20%	- 從舊版本移轉 - 升級後驗證 - 升級準備與規劃

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

問題 #1

Which two workload management thresholds support priority aging by providing a remapping action? (Choose two.)

A. ACTIVITYTOTALTIME
B. CPUTIMEINSC
C. REMAPACTIVITY
D. CONCURRENTDBCOORDACTIVITIES
E. SQLROWSREADINSC

答案：B,E

問題 #2

Which command will enable reads on an High Availability and Disaster Recovery (HADR) standby server?

A. db2set DB2_HADR_READ=STANDBY
B. db2set DB2_HADR=ROS
C. db2set DB2_HADR_ROS=ON
D. db2set DB2_HADR=STANDBY

答案：C

問題 #3

Which SQL statement will archive the audit log for the connected database?

A. SELECT * FROM TABLE(SYSPROAUDIT_ARCHIVE(NULL, NULL)) AS t1
B. CALL SYSPROC.AUDIT_ARCHIVE_LOG(' ', -1)
C. SELECT * FROM TABLE(SYSPROC.AUDIT_ARCHIVE_LOG(' ', -1)) AS t1
D. CALL SYSPROC.AUDIT_ARCHIVE(NULL, NULL)

答案：D

問題 #4

You have created a Trusted Context by using following command:

What is the ENCRYPTION type for the '9.26.146.201' address, the AUTHENTICATION type for
PUBLIC, and is MYCTX enabled?

A. High, WITHOUT AUTHENTICATION, No
B. None, WITH AUTHENTICATION, No
C. High, WITH AUTHENTICATION, Yes
D. None, WITHOUT AUTHENTICATION, Yes

答案：D

問題 #5

Table TAB_A and index TABA_IDX were created by executing these SQL statements:

If this SQL statement is executed after 100,000 records have been inserted into table TAB_A:
ALTER INDEX taba_idx COMPRESS NO;
Which statement correctly describes what will happen to index TABA_IDX?

A. The index will be uncompressed immediately.
B. The index will remain compressed until the COMPRESS attribute for table TAB_A has been set to NO and both the table and the index have been REORGed.
C. The index will remain compressed until the COMPRESS attribute for table TAB_A has been set to NO.
D. The index will remain compressed until it is REORGed.

答案：D