IBM DB2 10.5 Assessment

  • $10.00

This IBM DB2 10.5 assessment is used to assess the assessment taker's knowledge on the DB2 database. The assessment includes various topics of DB2 databases including database Administration and design, security, creating database objects, SQL, Concurrency and data types in DB2. The assessment is designed for the users who are having at least 1 year of experience working in DB2.

Number of questions 54
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered Concurrency
Database Administration and Design
Databases and Database Objects
DB2 Data types
DB2 using SQL
Tasks tested Activate Event Monitors
Available Database Directories
Check Roles Assigned to User
Check Table Space Utilization
Clustered Tables in DB2
Commit, Rollback and Savepoint in DB2
Compiling DB2 Stored Procedures
Conditional Updating Data for Multiple Rows into Table
Connecting to a DB2 Database
Convert Row-Organized Table to Column-Organized Table
Create a User-Defined Module Global Variable
Create tables using extended row size feature
Creating Database
Creating DB2 Stored Procedures
Database Configuration
Database Object Creation
DB2 Authorities - Upgrade/Delete/Revoke Privileges
DB2 LOAD Authority
DB2 SQL Joins
DB2 Triggers
Default Bufferpool Size
Default Tablespace in DB2
DMS vs SMS Table Spaces
Exporting Data in DB2
Expression-Based Index
Fetch First 10 Rows
Foreign Key Constraint
Formatting DB2 Explain Plans
Grant SYSCTRL Authority
Granting Privileges in DB2
Hidden Columns of a Table
Initialize DB2 Command Line Environment
Large Graphics Character Data
List of Tables Containing Specified Column
Listing DB2 Indexes
Locking Tables
Locks an Application is Waiting for
LOCKTIMEOUT Parameter in Database Configuration
Modifying the Size of Column
Nested Queries in DB2
Order of Precedence
RCAC (Row and Column Access Control)
Reorganizing Tables
Restrictions of HADR
SQL Clauses
Table Locking
Table Structure Definition
Table Views
Updating Data into Table
User Defined Data Types
Viewing Tables in Schema
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)