IBM DB2 11.1 Assessment

$16.00

IBM DB2 11.1 Assessment

$16.00
description

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

 

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