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 are the uses of DB2 Optimizer?
What component checks DB2 deadlocks?
Can you define CHECK constraint?
What is SQLCA’s maximum length?
What is BIND step in a DB2 program?
What are the common SQL error codes?
What are the most asked SQLCODE errors in DB2 Interview?
What are the three types of page locks that can be held.
Can you explain storage group (STOGROUP)?
What does DSNDB07 database do?
Can you explain Declaration Generator (DCLGEN)?
What are the buffer pools in DB2?
Can you explain clustering index?
Can you explain the Function done by data manager?
Can you explain correlated sub-queries?
Explain Comment whether the cursor is closed during COMMIT or not?
What is the highlighting as well as putting a CURSOR to use in a COBOL program?
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?
What are the some fields that are a part of SQLCA?
Can you explain the contents that are a part of DCLGEN?
What are the two most DB2 interfaces?
What is the different address spaces used 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?