Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 4494

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

5 6765

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

1 12400

What is meant by isolation level?

3 5087

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 5078

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 3540

What is a DB2 catalog?

2 5697

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

4 5034

What is the purpose of the WHENEVER statement?

1 3971

Is there any advantage to denormalizing DB2 tables?

1 5276

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

2 4003

What is sqlcode -922 ?

2 24288

What is lock escalation?

2 12293

What is the difference between primary key & unique index ?

Patni, Temenos,

6 23718

What is a DB2 bind?

3 5304

Post New DB2 Questions

Un-Answered Questions { DB2 }

Who uses db2?


How can deadlocks be resolved?


What is a page in db2?


How do I delete a table in database?


What is database reorganization?


What is cursor with hold option in db2?


What is dclgen in db2?


What does db2 stand for?


What is the difference between drop table and delete table?


Define declaration generator (dclgen).


Explain about open switch business continuity software?


How to restart a DB2 program?


What is the latest version of ibm db2?


Can one database have multiple instances?


Explain dclgen.