1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

What is the cascade rule and how does it relate to deletions made with a subselect?

 1 4796

When is the results table for the query in a DECLARE CURSOR statement created?

 5 7455

What does it mean if the null indicator has -1, 0, -2?

 1 12800

What is meant by isolation level?

 3 5579

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

 3 5606

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

 2 4012

What is a DB2 catalog?

 2 6152

Why might full image copies be faster to implement than an incremental image copy?

 4 5534

What is the purpose of the WHENEVER statement?

 1 4276

Is there any advantage to denormalizing DB2 tables?

 1 5754

What are some SQL aggregates and other built-in functions?

 2 4399

What is sqlcode -922 ?

 2 24986

What is lock escalation?

 2 13088

What is the difference between primary key & unique index ?

Patni, Temenos,

6 24745

What is a DB2 bind?

 3 5897

Post New DB2 Questions

Un-Answered Questions { DB2 }

Can there be more than one cursor open for any program?

652

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

694

Why do we need reorg in db2?

553

How do you select a row using indexes in db2?

633

What is the connection string to connect to the DB2 Database ?

606




What r the comman abends in db2, jcl and cobol???????

1810

What is null indicator in db2?

591

What is a storage group (stogroup)?

766

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?

6806

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

642

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2367

What do you mean by between and in? Is between inclusive of specified range values?

654

How to connect to db2 database from windows command line?

553

What is db2? Explain.

593

What is a Foreign Key?

648

For More Un-Answered { DB2 } Questions Click Here