C2090-730 DB2 9 Family Fundamentals

Test information:
Number of questions: 64
Time allowed in minutes: 90
Required passing score: 59%
Languages: English, Japanese

Related certifications:
IBM Certified Application Developer – DB2 9.7 for Linux, Unix and Windows
IBM Certified Database Administrator – DB2 9.7 for Linux, Unix and Windows
IBM Certified Advanced Deployment Professional – Tivoli Service Management Solutions 2008
IBM Certified Advanced Database Administrator – DB2 9.7 for Linux, UNIX and Windows
IBM Certified Database Associate — DB2 9 Fundamentals
IBM Certified Database Administrator – DB2 9 DBA for z/OS
IBM Certified Database Administrator – DB2 10.1 for Linux, UNIX, and Windows
IBM Certified Solution Designer — DB2 Business Intelligence V8
IBM Certified Database Administrator – DB2 10 for z/OS
IBM Certified Solution Developer – DB2 9.5 SQL Procedure Developer
IBM Certified Solution Developer – DB2 9.7 SQL Procedure
IBM Certified Application Developer – DB2 9
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows
IBM Certified Database Administrator – DB2 10.5 DBA for LUW Upgrade from DB2 10.1
IBM Certified System Administrator – DB2 9 for z/OS
IBM Certified System Administrator – DB2 10 for z/OS

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.

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, configuration 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 – Working with Databases and Database Objects (17%)
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 – Working 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 – Working 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 locking
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

QUESTION 1
Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2CPUs?

A. DB2 Everyplace
B. DB2 Express Edition
C. DB2 Workgroup Server Edition
D. DB2 Enterprise Server Edition

Answer: B

QUESTION 2
Which of the following products is allowed to access other DB2 servers, but cannot accept requests from otherremote clients?

A. DB2 Personal Edition
B. DB2 Workgroup Server Edition
C. DB2 Enterprise Server Edition
D. DB2 Data Warehouse Edition

Answer: A

QUESTION 3
A client application on z/OS must access a DB2 database on a Solaris Server. At a minimum, which of the following products must be installed on the Solaris workstation?

A. DB2 Connect Enterprise Edition
B. DB2 Workgroup Server Edition
C. DB2 Workgroup Server Edition and DB2 Connect Enterprise Edition
D. DB2 Enterprise Server Edition and DB2 Connect Enterprise Edition

Answer: D

QUESTION 4
Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?

A. DB2 Express-C
B. DB2 Express
C. DB2 Personal Edition
D. DB2 Enterprise Server Edition

Answer: D

QUESTION 5
Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database?

A. DB2 Enterprise Server Edition
B. DB2 Personal Developer’s Edition
C. DB2 UniversalDeveloper’s Edition
D. DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition

Answer: C

Click here to view complete Q&A of C2090-730 exam
Certkingdom Review, Certkingdom PDF C2090-730