試験番号:C2090-611
試験名称: DB2 10.1 DBA for Linux, UNIX, and Windows
問題数:59
試験時間:90
合格率:61%
試験言語:英語、日本語
対応資格:
IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and Windows
IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows
IBM Certified Advanced Deployment Professional - IBM Service Management Service Delivery and Process Automation V5
IBM Certified Database Administrator - DB2 10.5 DBA for LUW Upgrade from DB2 10.1
IBM Certified Advanced Deployment Professional - IBM Service Management Asset Management V5
DB2 10.1に精通しており、DB2インスタンスおよびデータベースの日々の管理に必要な中級から上級のスキルを実行できる場合は、この認定資格の恩恵を受ける可能性があります。
Testpassportは、インターネット上で最高のC2090-611問題集です。
最新のIBM Certified Advanced Deployment Professional C2090-611勉強資料が非常に近く、真の試験問題があります。
常にTestpassportのC2090-611試験材料をアップグレードします。
C2090-611無料サンプルをご参考ください。
1.Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is
reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad
pages were detected in table space TBSP_1.
What command can be used to recover the database and repair the corruption in table space TBSP_1?
A. RESTART DATABASE
B. RECOVER DATABASE
C. RESTORE TABLESPACE
D. ROLLFORWARD DATABASE
Answer: B
2.If a single node database is actively being used by applications when a power failure occurs, what
method is used to bring the database back to a consistent state once power has been restored.?
A. Crash recovery
B. Version recovery
C. Disaster recovery
D. Roll-forward recovery
Answer: A
3.You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read
from the standby database. What must you do?
A. Assign the value ON to the DB2_HADR_ROS registry variable.
B. Assign the value ON to the DB2_HADR_SNAP registry variable.
C. Execute the STOP HADR command to temporarily break the HADR connection to the standby.
D. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new
primary database.
Answer: A
4.Which command can be used to restore a corrupted database using only the recovery history file?
A. RESTART DATABASE
B. RECOVER DATABASE
C. RESTORE DATABASE
D. ROLLFORWARD DATABASE
Answer: B
弊社のIBM Certified Advanced Deployment Professional C2090-611参考書を使って、10~20時間の独学だけで、お客様の時間と精力を節約して、一発合格が可能です。
弊社のIBM Certified Advanced Deployment Professional C2090-611テキストを勉強すると、試験を気楽に通せることできます。
真実なIBM Certified Advanced Deployment Professional C2090-611問題集を提供することに力を尽くしています。
IBM Certified Advanced Deployment Professional C2090-611出題内容:
Section 1 - DB2 Server Management (10%)
Demonstrate the ability to configure/manage DB2 servers, instances, and databases
Demonstrate the ability to use autonomic features
Demonstrate the ability to use Data Studio
Demonstrate the ability to schedule jobs
Demonstrate the ability to use visual explain
Section 2 - Physical Design (26%)
Demonstrate the ability to create a database and manipulate various DB2 objects
How to convert existing db to automatic storage db
Admin_move_table feature
Demonstrate knowledge of partitioning capabilities
Demonstrate knowledge of XML data objects
Demonstrate knowledge of compression
Demonstrate knowledge of new table features
Knowledge of Multi-temperature data feature
Section 3 - Business Rules Implementation (8.5%)
Demonstrate the ability to create constraints on tables
Demonstrate the ability to create views WITH CHECK OPTION
Demonstrate the ability to create and using triggers
Demonstrate the ability to use the set integrity command
Section 4 - Monitoring DB2 Activity (10%)
Demonstrate the ability to use Admin views and SQL functions for monitoring
Knowledge of Work Load Manager monitoring features
Demonstrate the ability to use additional auto-monitoring tools
Demonstrate the ability to identify the functions of Problem Determination Tools
Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
Section 5 - Utilities (14%)
Demonstrate the ability to use traditional data movement utilities
Demonstrate the ability to use the Ingest utility
Demonstrate the ability to use the REORG, REORGCHK, REBIND, RUNSTATS and FLUSH PACKAGE CACHE utilities
Demonstrate the ability to use the DB2 Design Advisor utility
Section 6 - High Availability (10%)
Describe DB2 data integrity actions (crash recovery, version recovery, roll forward recovery)
Demonstrate the ability to perform database-level and table space level backup and recovery operations
Demonstrate the ability to configure and manage HADR (read from standby)
Demonstrate knowledge of DB2 pureScale (HA features only)
Section 7 - Security (15%)
Describe DB2 authorizations and privileges
Knowledge of the security administrator role
Demonstrate general knowledge of the Audit facility
Demonstrate knowledge of the trusted context
Demonstrate knowledge of row column access control (RCAC)
Demonstrate knowledge of LBAC
Section 8 - Connectivity and Networking (6.5%)
Demonstrate the ability to configure database connectivity
Demonstrate knowledge of DB2 Discovery
Demonstrate knowledge of LDAP
試験名称: DB2 10.1 DBA for Linux, UNIX, and Windows
問題数:59
試験時間:90
合格率:61%
試験言語:英語、日本語
対応資格:
IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and Windows
IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows
IBM Certified Advanced Deployment Professional - IBM Service Management Service Delivery and Process Automation V5
IBM Certified Database Administrator - DB2 10.5 DBA for LUW Upgrade from DB2 10.1
IBM Certified Advanced Deployment Professional - IBM Service Management Asset Management V5
DB2 10.1に精通しており、DB2インスタンスおよびデータベースの日々の管理に必要な中級から上級のスキルを実行できる場合は、この認定資格の恩恵を受ける可能性があります。
Testpassportは、インターネット上で最高のC2090-611問題集です。
最新のIBM Certified Advanced Deployment Professional C2090-611勉強資料が非常に近く、真の試験問題があります。
常にTestpassportのC2090-611試験材料をアップグレードします。
C2090-611無料サンプルをご参考ください。
1.Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is
reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad
pages were detected in table space TBSP_1.
What command can be used to recover the database and repair the corruption in table space TBSP_1?
A. RESTART DATABASE
B. RECOVER DATABASE
C. RESTORE TABLESPACE
D. ROLLFORWARD DATABASE
Answer: B
2.If a single node database is actively being used by applications when a power failure occurs, what
method is used to bring the database back to a consistent state once power has been restored.?
A. Crash recovery
B. Version recovery
C. Disaster recovery
D. Roll-forward recovery
Answer: A
3.You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read
from the standby database. What must you do?
A. Assign the value ON to the DB2_HADR_ROS registry variable.
B. Assign the value ON to the DB2_HADR_SNAP registry variable.
C. Execute the STOP HADR command to temporarily break the HADR connection to the standby.
D. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new
primary database.
Answer: A
4.Which command can be used to restore a corrupted database using only the recovery history file?
A. RESTART DATABASE
B. RECOVER DATABASE
C. RESTORE DATABASE
D. ROLLFORWARD DATABASE
Answer: B
弊社のIBM Certified Advanced Deployment Professional C2090-611参考書を使って、10~20時間の独学だけで、お客様の時間と精力を節約して、一発合格が可能です。
弊社のIBM Certified Advanced Deployment Professional C2090-611テキストを勉強すると、試験を気楽に通せることできます。
真実なIBM Certified Advanced Deployment Professional C2090-611問題集を提供することに力を尽くしています。
IBM Certified Advanced Deployment Professional C2090-611出題内容:
Section 1 - DB2 Server Management (10%)
Demonstrate the ability to configure/manage DB2 servers, instances, and databases
Demonstrate the ability to use autonomic features
Demonstrate the ability to use Data Studio
Demonstrate the ability to schedule jobs
Demonstrate the ability to use visual explain
Section 2 - Physical Design (26%)
Demonstrate the ability to create a database and manipulate various DB2 objects
How to convert existing db to automatic storage db
Admin_move_table feature
Demonstrate knowledge of partitioning capabilities
Demonstrate knowledge of XML data objects
Demonstrate knowledge of compression
Demonstrate knowledge of new table features
Knowledge of Multi-temperature data feature
Section 3 - Business Rules Implementation (8.5%)
Demonstrate the ability to create constraints on tables
Demonstrate the ability to create views WITH CHECK OPTION
Demonstrate the ability to create and using triggers
Demonstrate the ability to use the set integrity command
Section 4 - Monitoring DB2 Activity (10%)
Demonstrate the ability to use Admin views and SQL functions for monitoring
Knowledge of Work Load Manager monitoring features
Demonstrate the ability to use additional auto-monitoring tools
Demonstrate the ability to identify the functions of Problem Determination Tools
Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
Section 5 - Utilities (14%)
Demonstrate the ability to use traditional data movement utilities
Demonstrate the ability to use the Ingest utility
Demonstrate the ability to use the REORG, REORGCHK, REBIND, RUNSTATS and FLUSH PACKAGE CACHE utilities
Demonstrate the ability to use the DB2 Design Advisor utility
Section 6 - High Availability (10%)
Describe DB2 data integrity actions (crash recovery, version recovery, roll forward recovery)
Demonstrate the ability to perform database-level and table space level backup and recovery operations
Demonstrate the ability to configure and manage HADR (read from standby)
Demonstrate knowledge of DB2 pureScale (HA features only)
Section 7 - Security (15%)
Describe DB2 authorizations and privileges
Knowledge of the security administrator role
Demonstrate general knowledge of the Audit facility
Demonstrate knowledge of the trusted context
Demonstrate knowledge of row column access control (RCAC)
Demonstrate knowledge of LBAC
Section 8 - Connectivity and Networking (6.5%)
Demonstrate the ability to configure database connectivity
Demonstrate knowledge of DB2 Discovery
Demonstrate knowledge of LDAP