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 5645

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

5 9441

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

1 13671

What is meant by isolation level?

3 6914

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 6969

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 5257

What is a DB2 catalog?

2 7258

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

4 7030

What is the purpose of the WHENEVER statement?

1 5166

Is there any advantage to denormalizing DB2 tables?

1 6720

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

2 5469

What is sqlcode -922 ?

2 26556

What is lock escalation?

2 14498

What is the difference between primary key & unique index ?

Patni, Temenos,

6 27254

What is a DB2 bind?

3 7196

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is an instance database?

1096

Is schema the same as database?

1102

What is the usage of open cursor command?

1143

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2261

What are types of indexes?

1187

What is the result of open cursor statement?

1125

What are the prerogatives?

1127

What is the clustering index in the db2 database?

1044

What is the use of runstats in db2?

1178

What is db2 bind process?

1288

What kind of database is db2?

1081

What is the difference between plan and package in db2?

1167

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

3006

What is the maximum number of columns in a db2 table?

1342

What is rct?

1287

For More Un-Answered { DB2 } Questions Click Here