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

  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 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

For More Un-Answered { DB2 } Questions Click Here