IBM证书的七个技术方向

2017-03-24 00:00:00小静 IBM认证

  IBM(国际商业机器公司)或万国商业机器公司,简称IBM(International Business Machines Corporation)。总公司在纽约州阿蒙克市。下面是小编整理的关于IBM证书的七个技术方向,欢迎大家参考!

  Exam 000-730 DB2 9 Family Fundamentals

  1. IBM DB2 Overview1.1 Introduction to IBM DB2 Servers and Clients1.3 Different Editions IBM DB2 of Various Platforms

  2. Deploying IBM DB2 for Windows2.1 Installation requirements for DB2 servers2.2 IBM DB2 Disk and Memory Requirements2.3 Configuring OS settings2.4 Installing IBM DB2 Database Server Enterprise Edition2.5 Installing IBM DB2 Database Server Enterprise Edition (Cont.)

  3. DB2 Tools3.1 Tools Overview3.2 The Control Center3.3 The Journal3.4 The Task Center3.5 Health Center3.6 Command Editor

  4. DB2 Command Line Processor (CLP)4.1 Using the DB2 Command Window4.2 Using the DB2 Command Line Processor CLP

  5. Basic Concept of IBM DB2 Database5.1 Components of an IBM DB2 Database5.2 Creating a DB2 Database5.3 Installing DB2 Client5.4 Connecting a client to DB25.5 Data Types5.6 Schema5.7 Table5.8 Referential Integrity - Creating Relationships Between Tables5.9 Altering a table5.10 Constraints5.11 Understanding Views

  6. Index6.1 Purpose of an Index6.1 Creating an Index (Cont.)6.2 Non-clustered and Clustered Index6.3 Non-Clustered Index with Included Columns6.4 Improving Update performance6.5 Composite Index (组合索引)6.6 Design Advisor6.7 Materialized Query Table (MQT)

  7. SQL7.1 Limit the amount of data returned by a query7.2 Sorting Results7.3 Retrieving data from multiple tables

  8. Sequence8.1 Introducing Sequence object8.2 Creating and Altering a Sequence8.3 Rolling back a transaction with sequence

  9. Understanding Transactions9.1 Understanding data consistency9.2 Understanding Unit of Work9.3 Effects of Commit and Rollback operations9.4 Using SAVEPOINT

  10. Understanding Concurrency and Isolation10.1 Phenomena that may occur when multiple users access a database10.2 Concurrency and Isolation Levels10.3 Repeatable Read

  Exam 000-731 DB2 9 DBA for Linux UNIX and WindowsSection 1 - DB2 Server Management

  Ability to configure/manage DB2 instances (e.g. scope)

  Ability to obtain/modify database manager configuration information

  Ability to obtain/modify database configuration information

  Knowledge of the DB2 force command

  Ability to configure client/server connectivity

  Ability to schedule jobs

  Ability to use Automatic Maintenance (i.e., RUNSTAT, Backup, REORG)

  Ability to configure client server connectivity using DISCOVERY

  Skill in interpreting the Notify log

  Ability to obtain and modify DB2 registry variables

  Ability to use Self-tuning memory managemer and autoconfig

  Ability to use Throttling utilities

  Section 2 - Data Placement

  Ability to create a database

  Skill in discussing the use of schemas

  Skill in discussing the various table space states

  Ability to create and manipulate the various DB2 objects

  Ability to create and discuss the characteristics of an SMS tablespace

  Ability to create and discuss the characteristics of an automated managed tablespace

  Knowledge of partitioning capabilities (e.g., Table partitioning, Hash partitioning, MDC, Hybrid)

  Knowledge of XML structure (indexing for performance)

  Knowledge of compression data

  Section 3 - Database Access

  Knowledge of the creation and management of indexes

  Ability to create constraints on tables (e.g., RI, Informational, Unique)

  Ability to create views on tables

  Skill in examining the contents of the System Catalog tables

  Ability to use the GUI Tools for administration

  Knowledge of how to enforce data uniqueness

  Section 4 - Analyzing DB2 Activity

  Ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information

  Ability to capture snapshots using Get Snapshots or SQL functions

  Ability to create and activate event monitors

  Ability to configure Health Monitor using the Health Center

  Ability to identify the functions of Problem Determination Tools (e.g, db2pd, db2mtrk)

  Section 5 - Utilities

  Ability to use EXPORT utility to extract data from a table

  Ability to use IMPORT utility to insert data into a table

  Ability to use the LOAD utility to insert data into a table

  Knowledge to identify when to use IMPORT vs. LOAD

  Ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities

  Ability to use DB2Move, DB2Look and DB2Batch

  Knowledge of the functionality of the DB2 Advisors (db2advis utility)

  Ability to use the DB2 Control Center

  Section 6 - High Availability

  Ability to perform database-level and table space level BACKUP & RESTORE

  Knowledge to identify and explain issues on index recreation

  Knowledge of database logging

  Knowledge of crash recovery

  Knowledge of version recovery

  Knowledge of Roll Forward recovery

  Knowledge of and ability to perform HADR

  Knowledge of and ability to perform Log Mirroring

  Knowledge of Configurable Online Parameters

  Section 7 - Security

  Knowledge of DB2 authentication

  Knowledge of DB2 authorizations

  Ability to set user and/or group privileges

  Knowledge of the DB2 Security Infrastructure (e.g. LBAC and Security Plug-ins)

[IBM认证]相关推荐

[IBM认证]相关栏目推荐
查看更多
上一篇:2016年IBM认证考试试题及答案 下一篇:IBM认证证书分类