subject: Know More About Test 000-610 Db2 10.1 Fundamentals [print this page] IBM Certified Database Associate - DB2 10.1 Fundamentals
This Database Associate qualification is a beginner examination for a personal of any of the DB2 category of items. This personal is experienced about the essential principles of DB2 10.1 through either arms on encounter or official and casual awareness. The database associate should have in-depth information of the primary to advanced projects needed in day-to-day management, primary SQL (Structured Question Language), comprehend which extra items are available with DB2 10.1 and comprehend how to make directories and database things, and have primary information of database protection and deal solitude.
Exam Objectives
Part 1 - Preparing (10%)
A.Awareness of DB2 items (z/OS vs. LUW vs. PureScale - at a high-level; different items & what they do)
B.Awareness of database workloads (appropriate DB2 item to use - OLTP vs. warehousing)
C.Awareness of non-relational data principles (XML data, LOB data)
Part 2 - Security (15%)
A.Awareness of reducing data accessibility
B.Awareness of different rights & government bodies
C.Given a DCL SQL declaration, information to recognize outcomes (grant/revoke/connect statements)
D.Awareness of Row & Pillar Access Management (RCAC)
E.Awareness of Tasks & Reliable Contexts
Part 3 - Dealing with Databases & Information source Objects (20%)
A.Capability to make & get connected to DB2 hosts & directories (requirements to give power to connect)
B.Capability to recognize DB2 things
C.Awareness of basic features & qualities of DB2 things
D.Given a DDL SQL declaration, information to recognize outcomes (Capability to make objects)
E.Awareness of Short-term (Time Travel) Systems - System-period, Application-period, & Bi-temporal - power to make (Greater perfection time stamps)
Part 4 - Dealing with DB2 Information using SQL (20%)
A.Capability to use SQL to SELECT data from tables
B.Capability to use SQL to SORT or GROUP data
C.Capability to use SQL to UPDATE, DELETE or INSERT data
D.Awareness of dealings (i.e., commit/rollback & deal boundaries)
E.Capability to make & call an SQL reinforced process or an individual described operate (understanding of moving aspects & results)
F.Given an Query declaration, information to recognize outcomes
G.Awareness of Short-term (Time Travel) Systems - System-period, Application-period & Bi-temporal - power to query
Part 5 - Dealing with DB2 Systems, Opinions & Crawls (22%)
A.Capability to show use of DB2 data kinds (XML data kinds, Oracle interface data types)
B.Given a scenario, power to make a brief desk
C.Awareness to recognize when referential reliability should be used
D.Awareness to recognize methods of information restriction
E.Awareness to recognize features of a desk, view or catalog
F.Awareness to recognize when activates should be used
G.Awareness of schemas
Part 6 - Information Concurrency (13%)
A.Awareness to recognize aspects that impact securing
B.Capability to list things on which hair can be acquired (lock table)
C.Awareness to recognize features of DB2 hair (common hair distributed across platforms)
D.Given a scenario, information to recognize the solitude levels that should be used (currently committed)
