IBM C2090-548 考試概覽:

認證廠商:	IBM
考試名稱:	IBM IMS 資料庫管理師 (C2090-548)
考試代碼:	C2090-548
考試形式:	選擇題, 情境導向題
考試時間:	未公開訂定標準（通常約90分鐘）
相關認證:	IBM 認證系統程式設計師 - IMS IBM 認證應用程式開發人員 - IMS
支援語言:	英文
及格分數:	未公開
實際考試題數:	未公開（依考試版本有所不同）
考試費用:	因地區與考試執行機構而異
證照有效期限:	通常為3年（IBM 認證效期可能隨課程更新而調整）
推薦課程:	IBM IMS 訓練課程
考試報名:	IBM 認證入口網站
範例考題:	IBM C2090-548 範例考題
考試方式:	線上遠端監考或實體考場應試（因地區與 IBM 合作考試機構而異）
必備條件:	建議具備 IBM IMS 資料庫系統相關經驗；曾參與 IMS 管理或開發工作者尤佳，但非強制要求
官方大綱網址:	https://www.ibm.com/training/certification

IBM C2090-548 考試大綱主題:

章節	目標
資料庫復原與持續運作能力	- 復原機制 1. 日誌式復原概念 2. 影像備份與異動累積 - 高可用性概念 1. 資料庫復原公用程式 2. 故障切換與重新啟動程序
效能與調校	- 效能監控 1. IMS 效能分析工具 2. 瓶頸辨識 - 最佳化技術 1. 資料庫存取最佳化策略 2. 緩衝區調校與儲存空間最佳化
IMS 環境與架構	- IMS 資料組織概念 1. 階層式資料庫模型基礎 2. 資料庫記錄與區段結構 - IMS 系統元件與架構 1. IMS DB/DC 架構概述 2. 控制區域與位址空間
資料庫定義與管理	- 資料庫維護作業 1. 資料庫配置與重組 2. 資料完整性管理 - 資料庫設計與 DBD/PSB 概念 1. 程式規格區塊 (PSB) 使用方式 2. 資料庫定義 (DBD) 建立與使用方式
安全性與存取控制	- 存取控制機制 1. 授權與驗證概念 2. IMS 安全架構

最新的 IBM Information Management C2090-548 免費考試真題：

1. What is the DB2 Load utility?

A) The DB2 Load utility is a tool that stores all scripts that are required to create the database. It does not load data, but just loads the database metadata that was exported for a site backup.
B) The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2 database.
C) The DB2 Load utility is a tool that allows you to directly transfer data and objects from another database into the one you are currently working with.
D) The DB2 Load utility can be used to load and create external functions in a DB2 database.

2. A client wants to Decommission an Oracle 9i application and an IMS application. They need to store the data in a central location. They will be accessing the data from various applications including COGNOS, Business Objects, and a home grown JDBC application. What is necessary to ensure success?

A) a Sun Solaris Server and Multiple Windows Desktops with Rhumba
B) Optim Data Growth with ODM/Optim Connect
C) Optim TDM, DP, and Archive with ODM/Optim Connect
D) an AIX Server, Windows Desktop, and Optim DRA

3. What is a DB2 instance?

A) DB2 does not use instances. It requires only databases to operate.
B) A DB2 instance is a copy of a database that can be accessed standalone from the database server.
C) A DB2 instance is just another name for DB2 Database.
D) A DB2 instance is a logical database manager environment where you catalog databases and set configuration parameters.

4. What is the DB2 Design Advisor?

A) The DB2 Design Advisor is a tool that can help you improve your database workload performance. Given a set of SQL statements in a workload, the Design Advisor can generate recommendations to improve the performance of SQL execution.
B) The DB2 Design Advisor is a tool that automatically analyzes your running database and continuously makes changes to your database to give it peak performance.
C) The DB2 Design Advisor is a tool that can be used to automatically create tables based on a physical data diagram.
D) The DB2 Design Advisor is a help desk facility that is available to all licensed DB2 owners that have paid their maintenance agreements with IBM. The tool is a web site that guides you through the design of your database, with the DBA responding to a series of questions. It produces a database schema that allows for quick database creation.

5. Which one of the following options is NOT a new feature introduced in DB2 10?

A) Multi-Temperature Data Management
B) Table Partitioning
C) Temporal Tables
D) INGEST utility

問題與答案：

問題 #1
答案： B

問題 #2
答案： B

問題 #3
答案： D

問題 #4
答案： A

問題 #5
答案： B