Test 730: DB2 9 Family Fundamentals

This Database Associate is an entry level DBA or a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 9 through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how DB2 9 is packaged and installed, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.
Save 50% off the retail price of this exam with the Certify and Save Promotion! Learn more…

Section 1 – Planning (14%)

Knowledge of restricting data access
Knowledge of the features or functions available in DB2 tools (just tools that come with product – distributed +space – i.e., control center, configuration advisor, configuraiton assistant, command line processor)
Knowledge database workloads (OLTP vs warehousing)
Knowledge of non-relational data concepts (extenders)
Knowledge of XML data implications (non-shreading)
Section 2 – Security (11%)

Knowledge of DB2 products (client, server, etc.)
Knowledge of different privileges and authorities
Knowledge of encryption options (data and network)
Given a DDL SQL statement, knowledge to identify results (grant/revoke/connect statements)
Section 3 – Worguide with Databases and Database Objects (17%)

Donwload Free PassGuide Braindumps-The Most Realistic Practice Questions and Answers,Help You Pass any Exams

Ability to identify and connect to DB2 servers and databases
Ability to identify DB2 objects
Knowledge of basic characteristics and properties of DB2 objects
Given a DDL SQL statement, knowledge to identify results (ability to create objects)
Section 4 – Worguide with DB2 Data using SQL (23.5%)

Given a DML 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
Knowledge of transactions (i.e., commit/rollback and transaction boundaries)
Ability to call a procedure or invoke a user defined function
Given an XQuery statement, knowledge to identify results
Section 5 – Worguide with DB2 Tables, Views and Indexes (23.5%)

Ability to demonstrate usage of DB2 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
Knowledge to identify when triggers should be used
Knowledge of schemas
Knowledge of data type options for storing XML data
Section 6 – Data Concurrency (11%)

Knowledge to identify factors that influence locguide
Ability to list objects on which locks can be obtained
Knowledge to identify characteristics of DB2 locks
Given a situation, knowledge to identify the isolation levels that should be used

PassGuide Cisco Exams Questions & Training Materials

  1. Free Test 700: DB2 V8.1 Family Fundamentals
  2. Free Oracle 11i General Ledger Fundamentals Training Curriculum cbt
  3. Free CBT Nuggets: CIW JavaScript Fundamentals
  4. Free Oracle 11i: General Ledger Fundamentals Training Curriculum
  5. Free IBM Training IMS Essentials Curriculum Training
  6. Free Oracle 9i Developer OCA Oracle Certified Associate
  7. Free IBM Test 142: IBM Certified Solution Developer – XML 1.1 and Related Technologies
  8. Free SQL Bible
  9. Free DEV353: Data Modeling with PowerDesigner 15
  10. Free preparepm.com Tutorial – Project Fundamentals
  11. Free 1z1-051
  12. Free Database Certification Spotlight: Office Specialist

About the Author

PassGuide Free Certification Exam Download has written 6442 stories on this site.

If you have any doubts about legality of content or you have another suspicions, feel free to contact us:CertGuard@Gmail.com

2 Comments on “Test 730: DB2 9 Family Fundamentals”

  • ranjit wrote on 18 September, 2010, 10:41

    mclx

Write a Comment

Gravatars are small images that can show your personality. You can get your gravatar for free today!

You must be logged in to post a comment.

Copyright © 2019 CertBible – IT certifications Exams,Study Guide,Practice Test,Training Materials.. PassGuide,Testinside,Pass4side,Certifyme,Transcender,Examworx,Topcerts,Actualtests. microsoft Comptia MCSE Oracle hp ibm citrix Sitemap