DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 5562

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

5 9249

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

1 13578

What is meant by isolation level?

3 6793

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 6847

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 5159

What is a DB2 catalog?

2 7148

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

4 6918

What is the purpose of the WHENEVER statement?

1 5061

Is there any advantage to denormalizing DB2 tables?

1 6647

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

2 5384

What is sqlcode -922 ?

2 26402

What is lock escalation?

2 14372

What is the difference between primary key & unique index ?

Patni, Temenos,

6 27026

What is a DB2 bind?

3 7068

Post New DB2 Questions

Un-Answered Questions { DB2 }

What are concurrency issues?

1095

What are foreign keys in db2?

1101

What is the use of db2?

1051

How would you find out the total number of rows in a db2 table?

1050

Which isolation level provides highest data integrity?

1114

i want to maintain uniqueness on pdf without make lf??????????

2153

How many types of page locks can be held in db2?

1038

Explain package in db2 and its advantages?

1212

What is plan in cobol db2?

1133

Mention the various locks that are available in db2.

1035

How can you do the explain of a dynamic sql statement?

1069

Define check constraint.

1076

Before you give the explain statement, what are the prerogatives?

1028

Why do we use cursor?

1097

What is a bind card?

1216

For More Un-Answered { DB2 } Questions Click Here