What is the physical storage length of DATE data type?

The physical storage length of TIME data type is 4 bytes.

How many types of page locks can be held in DB2?

Three types of page locks can be held in DB2:

Exclusive
Update
Share

What is DBRM?

DBRM stands for Database Request Module. It is a component inside DB2, which is created by the pre compiler of DB2. It contains SQL source statements that get extracted out of the application program. DBRMs form inputs that are helpful in the binding process.

Which isolation level provides maximum concurrency?

Uncommitted read provides maximum concurrency.

Which component is responsible for DB2 startup and shutdown?

System Services component is responsible for handling DB2 startup and shutdown.

What is the usage of OPEN CURSOR command?

If you use the OPEN CURSOR command with ORDER BY clause, the rows are fetched, sorted and made available for the FETCH statement. Otherwise simply the cursor is placed on the first row.

What is the maximum size of a CHAR data type in DB2?

The maximum size of a CHAR data type in DB2 is 254 bytes.

What is buffer Pool?

Buffer pool is part of main memory space. This space is allotted by the database manager. It cache table and index data from the disk.

Which isolation level provides highest data integrity?

Repeatable Read provides highest data integrity as it holds page and lock the rows until a COMMIT point.

What is the use of COMMIT in DB2?

COMMIT is used to change the data permanently by commits the database changes occur in the current transaction and made that changes permanent.