DB2 Interview Questions and Answers

DB2 is the relational database management system(RDMS) which is specially designed to store, analyze and retrieve the data efficiently.

The data types that are available in the DB2 database are:-

• SMALLINT
• INTEGER
• FLOAT
• DECIMAL
• CHAR
• VARCHAR
• DATE
• TIME

DB2 optimizer processes the SQL statements, and it also helps to select the access path

DBRM stands for Database Request Module.DBRM is the component inside DB2, which is created by the precompiler of DB2. DRBM consists of the SQL source statements which get extracted out of the application program.DBRMs form the inputs which are very helpful in the binding process.

Concurrency is the period when more than one DB2 application process can access the same data at the same time.

DB2 database has a component which manages the physical database, and also it requests the system components to perform the operations like locking, logging, etc. and also to perform I/O operations.

A clustering index is a type of index, which locates the roes of the table and determines how to group these rows in the tablespace.

Data page retrieves the data from the database. The database from which the data can be extracted is in the form of 4 kilobytes or 32 kilobytes. Data page also includes the information regarding the user that is part of the database.

The user can find the number of rows in the DB2 tables by using the SELECT COUNT (*) on the DB2 query.

This question has always been a center of the discussion in db2 Interview Questions.

A user can eliminate the duplicate values from DB2 SELECT by using SELECT DISTINCT in DB2 query.