DB2 Interview Questions and Answers

DB2 Interview Questions and Answers

Database 2 (DB2) is a Relational database management system developed by IBM .It is an Open source database system for computing systems. It supported object oriented database features and Non relational structure with XML.Using SQL, users can obtain data simultaneously from DB2and other different databases. Although DB2 was initially designed to work exclusively on IBM mainframe platforms, it was later ported to other widely used operating systems like UNIX, Windows and presently in Linux.

What is DB2?

Can you define COMMIT?

What are the uses of DB2 Optimizer?

What component checks DB2 deadlocks?

Can you define SQLCA?

Can you define CHECK constraint?

What is SQLCA’s maximum length?

What is BIND step in a DB2 program?

Can you explain SQLCODE?

What are the common SQL error codes?

Can you explain DB2 Bind?

What are the most asked SQLCODE errors in DB2 Interview?

What are the three types of page locks that can be held.

What is buffer pool?

Can you explain SQLSTATE?

What is DB2 catalog?

What is Data Manager?

Can you explain storage group (STOGROUP)?

What does DSNDB07 database do?

Can you define predicate?

Can you explain Declaration Generator (DCLGEN)?

What are the buffer pools in DB2?

Can you explain clustering index?

Can you define concurrency?

Can you explain the Function done by data manager?

Can you explain DBRM?

Can you explain Data page?

Can you explain correlated sub-queries?

Explain Comment whether the cursor is closed during COMMIT or not?

In an SQL table that is embedded, what is the procedure to retrieve rows that are part of a DB2 table?

What is the highlighting as well as putting a CURSOR to use in a COBOL program?

If the CURSOR is kept open followed the issuing of COMMIT, what is the procedure to leave the CURSOR that way?

Can you define PACKAGES?

What are the some the advantages that are attached to a PACKAGE?

What is the length of physical storage of the given data types of DB2 – DATE, TIMESTAMP, TIME?

Can you define DCLGEN?

What are the some fields that are a part of SQLCA?

Can you explain the contents that are a part of DCLGEN?

Can you explain comment whether DCLGEN is mandatorily used. If not, then what is the point of using it?

What are the two most DB2 interfaces?

In case if at some point of time DB2 is down, would that impact the pre-compilation process of a DB2-COBOL program?

Following a DB2 update statement, what is the quickest way to compute the total number of updated rows?

What is the different address spaces used in DB2?

What is EXPLAIN in DB2?

What are the prerogatives, before you give the EXPLAIN statement,?

What is a corelated subquerry?

Can you explain Outputs of EXPLAIN are with MATCHCOLS = 0. What does this signify?

Can you define RELEASE/ACQUIRE in BIND?

What a storage group (stogroup) is?

What are the levels of isolation available with DB2v4?

How do you declare a host variable (in COBOL) for an attribute named EMP-name of type varchar (25)?

What is the size of a data page?

What are the different locking levels that are available in DB2?

How you will count the number of rows from a table TAB?

What are the various locks that are available in DB2?

What are the downsides of PAGE level lock?

What are the different commands used in DB2?

What is the difference between TYPE 1 index & TYPE 2 index?