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

DB2 Interview Questions

Questions Answers Views Company eMail

What is a lock?

1 4874

What should be specified along with a cursor in order to continue updating process after commit?

IBM,

1 5343

How does DB2 use multiple table indexes?

1 5704

What is meant by repeatable read?

4 10257

Compare a subselect to a join?

1 4878

Describe the elements of the SELECT query syntax?

3 6362

What is the command used by TSO users to invoke DB2?

IBM,

2 9292

What is the FREE command?

1 5055

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2783

What is DB2 (IBM Database 2)?

3 5510

What is QUIESCE?

2 13075

what is the name of the default db2 catalog database?

IBM,

3 8388

What are the three DB2 date and time data types and their associated functions?

1 5306

What is the significance of DB2 free space and what parameters control it?

1 5355

Explain the EXPLAIN statement?

1 4888

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is catalog database in db2?

1105

Name the various locking levels available?

1038

What are the prerogatives?

1021

What are the various isolation levels possible?

1052

define clustering index.

980

What happens in bind step in a db2 program?

917

How do you find the maximum value in a column in db2?

1059

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3526

Is it possible using max on a char column?

1088

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1046

What is buffer pool in the db2 database?

1051

What is the use of db2?

1010

How to resolve deadlock issue

19878

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2181

What is an instance in db2?

989

For More Un-Answered { DB2 } Questions Click Here