DB2 Interview Questions
Questions Answers Views Company eMail

What is a lock?

1 4370

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

IBM,

1 4525

How does DB2 use multiple table indexes?

1 5156

What is meant by repeatable read?

4 9160

Compare a subselect to a join?

1 4280

Describe the elements of the SELECT query syntax?

3 5453

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

IBM,

2 8615

What is the FREE command?

1 4501

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

2381

What is DB2 (IBM Database 2)?

3 4624

What is QUIESCE?

2 12419

what is the name of the default db2 catalog database?

IBM,

3 7566

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

1 4808

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

1 4819

Explain the EXPLAIN statement?

1 4389


Post New DB2 Questions

Un-Answered Questions { DB2 }

Define db2.

755


How can deadlocks be resolved?

625


What is difference between rollback and commit?

730


What is an instance in db2?

646


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1722






What are union and union all?

623


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2848


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

7099


What is load replace in db2?

639


What is the maximum length of sqlca?

976


What is the syntax for FETCH in DB2 ?

764


Which is faster delete or truncate?

766


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

831


Why do we need reorg in db2?

642


What are bind parameters in db2?

689