DB2 interview questions – page 2

How do you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP ?

Can the OCCURS clause be at the 01 level?

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

EXPLAIN has output with MATCHCOLS = 0. What does it mean? ?

Will precompile of an DB2-COBOL program bomb, if DB2 is down?

How do you do the EXPLAIN of a dynamic SQL statement?

What are the various locking levels available?

What is sqlcode -922 ?

What is the self-referencing constraint?

How many clustering indexes are pasing for a table?

What is a LIKE table and how is it created?

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

When is the access path determined for dynamic SQL?

I have 1000 records in vsam,I want to read records 500 to 900

Suppose there is cobol-db2 program.I made changes only in the cobol program.Is there need recomile the DBRM again?why?

Where do you specify them ?

What is an alias and how does it differ from a synonym?

What are delete-connected tables?

What is the indexset and sequence set in vsam ksds?

What is the physical storage length of each of the following DB2 data types:DATE, TIME, TIMESTAMP?

How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?

What is a DB2 plan?

What do the initials DDL and DML stand for and what is their meaning?

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only )

How to see the status of the table?

What is a collection?

Can you display the index?

File contains 5 records say D,E,F,C,A-I want to copy D and A records only by using file-aid?

How is a typical DB2 batch pgm executed ?