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 5570

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

5 9258

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

1 13594

What is meant by isolation level?

3 6798

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 6859

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 5161

What is a DB2 catalog?

2 7157

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

4 6922

What is the purpose of the WHENEVER statement?

1 5066

Is there any advantage to denormalizing DB2 tables?

1 6649

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

2 5390

What is sqlcode -922 ?

2 26416

What is lock escalation?

2 14375

What is the difference between primary key & unique index ?

Patni, Temenos,

6 27047

What is a DB2 bind?

3 7073

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to view db2 table structure?

1018

What is the physical storage length of the data types date, time, and timestamp?

1090

Which command is used to connect to a database in DB2 ? Give the Syntax.

1104

What is the difference between drop table and delete table?

1212

What is db2?

1183

What is null indicator in db2?

1113

What are the prerogatives?

1080

Explain package in db2 and its advantages?

1219

Describe major components of db2?

1094

What is the use of db2 optimizer?

1117

What is blu acceleration in db2?

1070

What are the different types of base tables?

1094

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1278

How is deadlock resolved?

1147

What do you mean by between and in? Is between inclusive of specified range values?

1092

For More Un-Answered { DB2 } Questions Click Here