subject: Passing Tips For Db2 10.1 Fundamentals Certification 000-610 Exam [print this page] DB2 is the Data-Management System by IBMDB2 is the Data-Management System by IBM. It is a new technology. Industry leading performance, scale, and reliability on platform choice from Linux, UNIX and Windows to z/OS is offered by DB2 software. Complete Software Package which allows creation, storage, updating and retrieving data in a Systematic Manner is provided in DB2. Data is physically stored in VSAM files. 000-610 certification exam is an entry level for DB2 users. Depth knowledge of the basic to intermediate tasks is required in day-to-day administration including Structured Query Language. Database creation, database objects creation and a basic knowledge of database security and transaction isolation is included in DB2 10.1 Fundamentals certification exam.
Prerequisite(s):
Requirements for taking DB2 10.1 Fundamentals certification exam are:
Little experience to use DB2 10
Structured Query Language basic skills
Test for DB2 10.1 Fundamentals certification:
DB2 10.1 Fundamentals certification requires one test:
Test 000-610 - DB2 10.1 Fundamentals
Exam Format:
Exam consists of multiple choice questions. Time allowed to solve the exam is 90 minutes. 66% marks are required to pass this exam. Test will be conducted only in English language.
Syllabus:
DB2 10.1 Fundamentals certification exam consists of following 6 sections:
Planning
oKnowledge of DB2 products, database workloads and non-relational data concepts
o10% of total exam
Security
oKnowledge of restricting data access, privileges and authorities, identify DCL SQL statement results, Row and Column Access Control, Roles and Trusted Contexts
o15% of total exam
Working with Databases and Database Objects
oAbility to create and connect to DB2 servers and databases, identify DB2 objects, basic characteristics and properties of DB2 objects knowledge, able to create objects, Temporal knowledge
o20% of total exam
Working with DB2 Data using SQL
oUse of SQL to SELECT , UPDATE, DELETE, or INSERT data from tables, SQL to SORT or GROUP data
o20% of total exam
Working with DB2 Tables, Views and Indexes
oKnowledge to identify when referential integrity should be used, methods of data constraint, characteristics of a table, view or index, triggers usage, schemas
o22% of total exam
Data Concurrency
oKnowledge to identify factors that influence locking, lock table, characteristics of DB2 locks, isolation levels usage
o13% of total exam
Tips to pass DB2 10.1 Fundamentals certification exam:
You can take recommended courses offered by IBM for the preparation of 000-610 exam. These courses are:
