下載最新試用版
我們對我們的產品非常有信心，所以我們不提供会给客户带去麻煩的產品。
IBM C2090-317 考試概覽:
| 認證廠商: | IBM |
|---|---|
| 考試名稱: | DB2 11 for z/OS 系統管理員 |
| 考試代碼: | C2090-317 |
| 支援語言: | English |
| 相關認證: | IBM Certified System Administrator - DB2 11 for z/OS |
| 考試形式: | 單選題, 複選題 |
| 考試時間: | 90 分鐘 |
| 實際考試題數: | 約60至70題 |
| 考試費用: | 200美元（IBM專業認證歷史報價；可能因地區而有所不同） |
| 證照有效期限: | 此認證已終止；原有效期限依終止政策而定 |
| 及格分數: | 官方未公佈及格分數（依據IBM評分方式，約為60%） |
| 範例考題: | IBM C2090-317 範例考題 |
| 考試方式: | 授權的IBM或Pearson VUE考試中心（歷史安排）；採電腦測驗方式辦理。 |
| 必備條件: | 無強制性前置考試。IBM建議具備DB2 for z/OS環境的實際管理經驗，並熟悉z/OS架構。 |
| 官方大綱網址: | https://www.ibm.com/training/certification/ |
IBM C2090-317 考試大綱主題:
| 章節 | 權重 | 目標 |
|---|---|---|
| DB2 架構與環境 | 15% | - DB2 子系統架構
|
| 安全性與授權 | 15% | - 安全管理作業
|
| 資料共用與系統運作 | 15% | - 運作管理作業
|
| 安裝與設定 | 15% | - 系統安裝與移轉
|
| 效能監控與調校 | 20% | - 效能管理
|
| 備份、復原與公用程式 | 20% | - 復原作業管理
|
最新的 System Administator C2090-317 免費考試真題：
問題 #1
One of your applications is experiencing long elapsed times. You notice from DB2 accounting data that 90% of the class 2 elapsed time consists of class 3 suspension time.
Which statement describes the behavior of the application?
A. The application spends the majority of its time waiting for buffer pool I/O and log I/O.
B. The application is the victim of excessive performance tracing.
C. The application contains complex SQL statements that are CPU intensive.
D. The application spends the majority of its time waiting on the network.
問題 #2
Your database administrators plan to start using XML and they plan to have the XML documents being validated using type modifiers.
You must make sure that they are able to make XSR schemas available for this.
Which stored procedure(s), if any, must at least be created and functioning for that?
A. No stored procedures need to be created.
B. XSRREGISTER. XSRCOMPLETE. XSRADDSCHEMADOC
C. XSR_REGISTER, XSR_COMPLETE
D. XSR_REGISTER
問題 #3
In order to guarantee complete security for your DB2 subsystem, which statement is correct?
A. BSDS and catalog VSAM data sets should always be protected by the BSDS system privilege
B. BSDS and catalog VSAM data sets should always be protected by an external security profile.
C. BSDS and catalog VSAM data sets should always be protected by the SYSADM authority.
D. BSDS and catalog VSAM data sets should always be protected by the MSTR address space.
問題 #4
Which method can be used to set the DB2 client information (workstation name, application name..) from a JDBC application using a type 4 connection?
A. Using the java.sql.Connection.setClientlnfo method
B. Using the SET_CLIENT_ID option during RRS SIGNON
C. Setting up a profile using the SPECIAL_REGISTER attribute in SYSIBM.DSNPROFILE ATTRIBUTES table
D. Using the SQL SET statement (eg. SET CURRENT CLIENT J/VRKSTNNAME = 'MYWS*)
問題 #5
Which trace can be helpful in determining the resources involved with locking (i.e. deadlocks, timeouts) at a subsystem level?
A. Statistics trace class 1
B. Accounting trace class 3
C. Accounting trace class 1
D. Statistics trace class 3
問題與答案：
| 問題 #1 答案： C | 問題 #2 答案： C | 問題 #3 答案： B | 問題 #4 答案： D | 問題 #5 答案： D |
0位客戶反饋
