DB2 Interview Questions – Set 05

What is the physical storage length of TIME data type? The physical storage length of TIME data type is 3 bytes. Which component is used to execute the SQL statements? Database Services component is used to execute the SQL statement. It also manages buffer pool. On which levels locks can be applied? Locking can be … Read more

DB2 Interview Questions – Set 04

What is CHECK constraint in DB2? Check constraint is a database rule that checks data integrity. Thus, only values from the domain for the attribute or column are allowed. What is the use of predicate? Predicates are used to enhance the performance of query. What is the use of DB2 Optimizer? DB2 Optimizer is used … Read more

DB2 Interview Questions – Set 03

What is RCT? Resource Control Table (RCT) is controller that directs the CICS DB2 interface. Using DSNCRCT, RCT can produce a micro table. What is SPUFI? SPUFI stands for SQL Processor Using File Input. Give the name of some fields form SQLCA. The following three are the fields from SQLCA: SQLCODE SQLERRM SQLERRD What is … Read more

DB2 Interview Questions – Set 02

What is the physical storage length of TIMESTAMP data type? TIMESTAMP data type takes 10 bytes and default is YYYY-MM-DD: HH: MM:SS-NNNNNN What is SQLCA? SQLCA stands for Server Query Language Communication Area. Basically, it is a collection of variables that may be updated after the execution of every SQL statement. A program having SQL … Read more

DB2 Interview Questions – Set 01

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 … Read more