Follow Our FB Page << CircleMedia.in >> 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?

423


How can deadlocks be resolved?

387


What is a page in db2?

435


How do I delete a table in database?

450


What is database reorganization?

433






What is cursor with hold option in db2?

459


What is dclgen in db2?

446


What does db2 stand for?

448


What is the difference between drop table and delete table?

404


Define declaration generator (dclgen).

512


Explain about open switch business continuity software?

411


How to restart a DB2 program?

1167


What is the latest version of ibm db2?

525


Can one database have multiple instances?

433


Explain dclgen.

550