下載最新試用版
973位客戶反饋
我們對我們的產品非常有信心，所以我們不提供会给客户带去麻煩的產品。
IBM C2090-546 考試概覽:
| 認證廠商: | IBM |
| 考試名稱: | DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade 升級考試 |
| 考試代碼: | 000-546 / C2090-546 |
| 考試費用: | $200 USD |
| 考試形式: | 選擇題 |
| 實際考試題數: | 39 |
| 支援語言: | English, Japanese |
| 及格分數: | 55% |
| 考試時間: | 90 minutes |
| 相關認證: | 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: 效能與調校 | 17.5% | - SQL 最佳化與統計資料 - 工作負載管理 - 記憶體與組態參數 |
| 主題 2: 監控與問題判斷 | 7.5% | - 鎖定與並行分析 - 診斷日誌分析 - 事件監控器與快照 |
| 主題 3: 安全與授權 | 12.5% | - 角色型存取控制 - 加密與稽核 - 驗證與授權模型 |
| 主題 4: 實體設計與儲存 | 22.5% | - 資料表空間與容器 - 索引設計與最佳化 - 資料分割與壓縮 |
| 主題 5: 安裝、移轉與升級 | 20% | - 從舊版本移轉 - 升級後驗證 - 升級準備與規劃 |
| 主題 6: XML 與進階功能 | 5% | - XML 儲存與索引 - XQuery 與 XML 更新 |
| 主題 7: 備份、復原與高可用性 | 15% | - 還原與向前復原 - 線上與離線備份策略 - HADR 與日誌功能強化 |
最新的 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
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
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)
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
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.
問題與答案：
| 問題 #1 答案： B,E | 問題 #2 答案： C | 問題 #3 答案： D | 問題 #4 答案： D | 問題 #5 答案： D |
114.43.46.* -
憑借著VCESoft我順利通過IBM的考試，也感謝你們及時更新C2090-546題庫讓我考試也能跟著同步。