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 5461

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

5 9028

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

1 13491

What is meant by isolation level?

3 6631

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 6704

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 5055

What is a DB2 catalog?

2 7046

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

4 6742

What is the purpose of the WHENEVER statement?

1 4949

Is there any advantage to denormalizing DB2 tables?

1 6560

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

2 5239

What is sqlcode -922 ?

2 26221

What is lock escalation?

2 14229

What is the difference between primary key & unique index ?

Patni, Temenos,

6 26746

What is a DB2 bind?

3 6915

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is alias in db2?

983

What is the role of union all and union

1071

What are the benefits of using the db2 database?

1156

Describe major components of db2?

1044

What is meant by dclgen?

1061

What is a storage group (stogroup)?

1189

Mention the downsides of page level lock.

1112

How do you stop a db2 database in linux?

960

What is db2 look?

971

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1103

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1020

what is db2 restart?

2104

How is deadlock resolved?

1082

What is table space in db2?

963

How do you eliminate duplicate values in db2?

1110

For More Un-Answered { DB2 } Questions Click Here