C2090-615 DB2 10.5 Fundamentals for LUW

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

This Database Associate certification is an entry level exam for a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 10.5 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 which additional products are available with DB2 10.5, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Section 1 – Planning (16%)
Knowledge of DB2 products (DB2 for LUW Editions and DB2 for z/OS � at a high level; when/why would you use each?)
Knowledge of database workloads (OLTP vs. Data Warehouse; what is the appropriate product to use for each?)
Knowledge of DB2 10.5 BLU Acceleration (i.e., the ability to configure a DB2 database for analytics, when BLU Acceleration should be used)
Knowledge of Oracle Compatibility Features

Section 2 – Security (18%)
Knowledge of restricting data access (authorities and privileges vs. views vs. RCAC vs. LBAC � at a high level; when is it appropriate to use each?)
Knowledge of different authorities and privileges
Given a DCL SQL statement, knowledge to identify results (GRANT/REVOKE/CONNECT statements)
Knowledge of Roles and Trusted Contexts

Section 3 – Working with Databases and Database Objects (16%)
Ability to create and connect to DB2 servers and databases
Ability to identify DB2 objects
Given a DDL SQL statement, knowledge to identify results (ability to create objects)
Knowledge of different types of tables available (Base vs. MDC vs. ITC vs. RCT vs. MQT vs. Partitioned vs. Temporal � at a high level; when is it appropriate to use each type?)

Section 4 – Working with DB2 Data Using SQL and Xquery (23%)
Ability to use SQL to SELECT data from tables
Ability to use SQL to UPDATE, DELETE, or INSERT data
Knowledge of transaction management (COMMIT, ROLLBACK, AUTOCOMMIT and SAVEPOINTs)
Ability to create and call an SQL supported procedure or a user defined function (understanding of passing parameters and obtaining results)
Knowledge of SQL compatibility enhancements
Given an XQuery statement, knowledge to identify results

Section 5 – Working with DB2 Tables, Views, and Indexes (13%)
Ability to demonstrate usage of DB2 data types (XML data types, Oracle compatibility data types)
Knowledge to identify characteristics of a table, view or index
Knowledge of temporary tables (how they are created and when they should be used)
Knowledge of triggers (how they function; when they might be used)

Section 6 – Data Concurrency (15%)
Knowledge to identify factors that influence locking
Ability to list objects on which locks can be obtained (LOCK TABLE statement)
Knowledge to identify characteristics of DB2 locks (common locks shared across platforms)
Given a situation, knowledge to identify the isolation levels that should be used (currently committed)

Click here to view complete Q&A of C2090-615 exam
Certkingdom Review