The DB2 9 Fundamentals exam (Exam 730) consists of 64 questions, and candidates have 90 minutes to complete the exam. A score of 59% or higher is required to pass this exam.
The primary objectives the DB2 9 Fundamentals exam (Exam 730) is designed to cover are as follows:
Knowledge of DB2 UDB products (client, server, etc.)
Knowledge of the features and functions provided by DB2 tools such as the Control Center, the Configuration Advisor, the Configuration Assistant and the Command Line Processor
Knowledge of database workloads (OLAP versus data warehousing)
Knowledge of non-relational data concepts (extenders)
Knowledge of XML data implications (non-shredding)
Knowledge of restricting data access
Knowledge of different authorities and privileges available
Knowledge of encryption options available (data and network)
Given a DCL SQL statement, ability to identify results (GRANT, REVOKE, CONNECT statements)
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, ability to identify results (ability to create DB2 objects)
Given a DML SQL statement, ability 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 INSERT, UPDATE, or DELETE 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
Ability to demonstrate proper usage of DB2 data types
Given a situation, ability to create a table
Ability to identify when referential integrity should be used
Ability to identify methods of data constraint
Ability to identify characteristics of a table, view or index
Ability to identify when triggers should be used
Knowledge of schemas
Knowledge of data type options for storing XML data
Ability to identify factors that influence locking
Ability to list objects on which locks can be obtained
Ability to identify characteristics of DB2 locks
Given a situation, ability to identify the isolation level that should be used