Description

This Database Associate certification is an access degree examination for a consumer of any of the DB2 for LUW own circle of relatives of merchandise. This character is informed approximately the essential ideas of DB2 11.1 for LUW thru both fingers on enjoy or formal and casual education. The database companion must have an in-intensity expertise of the fundamental to intermediate duties required in daily administration, fundamental SQL (Structured Query Language), recognize which extra merchandise are to be had with DB2 11.1, recognize the way to create databases and database items, and feature a fundamental expertise of database protection and transaction isolation.

Recommended Skills

Entry degree enjoy the use of DB2 11

Basic expertise of SQL

Requirements

Exam C2090-616: DB2 11.1 Fundamentals for LUW

Exam Objectives

Please word this examination has been withdrawn

Number of questions: 63

Number of inquiries to pass: 43

Time allowed: 90 minutes

Status: Withdrawn

Section 1: Planning21%

 1. Identify and describe the DB2 merchandise to be had

 2.  Identify and describe the DB2 Cloud services to be had

 3. Describe the traits of OLTP and Data Warehouse workloads

 4. Describe the blessings of DB2 pureScale

 5. Demonstrate the cappotential to apply DB2 BLU Acceleration

 6. Explain Federation support

 7. Identify and describe Oracle and Netezza Compatibility Features

Section 2: Security17�scribe strategies used to limition facts access

Identify and describe the government and privileges to be had

Identify and describe the DCL statements to be had

Describe Roles and Trusted Contexts

Section 3: Working with Databases and Database Objects16%

Create and connect with DB2 servers and databases

Identify DB2 items

Identify and describe the DDL statements to be had

Describe the special varieties of tables to be had

Section 4: Working with DB2 Data the use of SQL19�monstrate the cappotential to apply SQL to SELECT facts from tables

Demonstrate the cappotential to apply SQL to UPDATE, DELETE, or INSERT facts

Demonstrate the cappotential to control transactions

Demonstrate the cappotential to create and make contact with an SQL saved technique or a consumer described feature

Identify and describe SQL compatibility enhancements

Identify the OLAP feature used to fulfill a selected commercial enterprise requirement

Section 5: Working with DB2 Tables, Views, and Indexes13%

Identify and describe the DB2 facts sorts to be had

Identify the traits of a table, view or index

Demonstrate the cappotential to create and use transient tables

Demonstrate the cappotential to create and use triggers

Section 6: Data Concurrency14%

Identify elements that impact locking

List items on which locks may be obtained

Identify traits of DB2 locks

Given a situation, pick out the isolation degree that must be used