当前页面位置: » 丰搜网 » 文档中心 » 详细内容
ibm--db2认证
终于过了700了，虽然很简单，但是很开心
http://www-900.ibm.com/developerworks/cn/dmdd/index.shtml ibm db2 开发者园地
http://www2.tw.ibm.com/developerworks/db2/tutorial/ developerworks (taiwan)
其实只要把那一两百页的英文资料看一遍，培训时候的题目都搞懂，ibm自测中心的自测题搞定加上一点点地运气就可以高分：）
不过701的题目还是有难度的，77题90分钟，59%过！
ps:
db2 udb v8.1 family fundamentals
test 700 objectives/skills measured on test
this exam contains a total of 54 questions. candidates are required to score 61% or better to pass the exam and will have 75 minutes to complete the exam.
section 1 - planning (15%)
knowledge of db2 udb products (client, server, etc.)
knowledge of the features in db2 tools such as: db2 extenders, configuration assistant, visual explain, command center, control center, relational connect, replication center, development center, and health center
knowledge of datawarehouse and olap concepts
knowledge of non-relational data concepts (extenders, etc)
section 2 - security (9%)
knowledge of restricting data access
knowledge of different privileges
accessing db2 udb data 15%
ability to identify and locate db2 udb servers
ability to access and manipulate db2 udb objects
ability to create basic db2 udb objects
working with db2 udb data 31%
knowledge of transactions
given a ddl sql statement, knowledge to identify results
given a dml sql statement, knowledge to identify results
given a dcl sql statement, knowledge to identify results
ability to use sql to select data from tables
ability to use sql to sort or group data
ability to use sql to update, delete, or insert data
ability to call a procedure
working with db2 udb objects 19%
ability to demonstrate usage of db2 udb data types
given a situation, ability to create table
knowledge to identify when referential integrity should be used
knowledge to identify methods of data constraint
knowledge to identify characteristics of a table, view or index
data concurrency 11%
