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)
-
J2EE程序员的技术标准是什么
J2EE核心是一组技术规范与指南,其中所包含的各类组件、服务架构及技术层次,均有共同的标准及规格,让各种依循J2EE架构的不同平台之间,存在良好的兼容性,解决过去企业后端使用的信息产品彼此之间无法兼容,企业内部或外部难以互通的窘境。下面小编整理的关于J2EE程序员...
-
2015年甘肃全国计算机等级考试报名公告
甘肃省2015年非学历教育全国统一考试报考简章一、全国计算机等级考试(NCRE)全国计算机等级考试(NationalComputerRankExamination,简称NCRE)是由教育部考试中心主办的,用于考查应试人员计算机知识与应用能力的全国性计算机水平统一考试。(一)开考级别及其定位NCR...
-
2017年计算机二级C语言模拟题及答案
1.1单选题1.下列变量名中,非法的是(C)。A.A25_car-str2.下列常量中,十六进制int型常量是(A)。A.0x5fB.x2aC.046D.7a3.下列常量中,不是字符常量的是(B)。A.'\n'B."y"C.'x'D.'\7'4.在函数体内定义了下述变量a,a的存储类为(D)。inta;A.寄存...
-
2017全国计算机二级office题库及答案
网络技术是从1990年代中期发展起来的新技术,它把互联网上分散的资源融为有机整体,实现资源的全面共享和有机协作,使人们能够透明地使用资源的整体能力并按需获取信息。下面是小编整理的关于全国计算机二级office题库及答案,欢迎大家参考!一、选择题1).一个字长为8...