DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What is rct?

1163

What is check constraint in db2?

1011

How can you count the number of rows from a table tab?

1039

Which components manage deadlocks in db2?

1016

What is the physical storage length of time data type?

1063

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

993

What is the picture clause of null indicator variable?

1080

Where can you declare a cursor in a cobol-db2 program?

994

What is concurrency in db2?

1 2103

Which component is responsible for db2 startup and shutdown?

980

What is data manager?

993

What is the physical storage length of date data type?

1188

Which isolation level provides highest data integrity?

1039

What is the reason behind not using select * in embedded sql programs?

1043

What is the maximum size of varchar data type in db2?

1065

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is meant by dclgen?

1060

What is a Foreign Key?

1036

What is sqlca’s maximum length?

1101

What is performance tuning db2?

1006

What language is db2 written in?

979

Define db2.

1063

How can deadlocks be resolved?

889

Can one database have multiple instances?

1005

What are concurrency issues?

1028

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4213

What is check constraint. Explain with example.

1043

Which components manage deadlocks in db2?

1016

What is package in cobol db2?

1075

What is clone table?

994

What is the use of db2 optimizer?

1036

For More Un-Answered { DB2 } Questions Click Here