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 5568

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

5 9254

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

1 13584

What is meant by isolation level?

3 6795

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 6858

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 7155

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

4 6920

What is the purpose of the WHENEVER statement?

1 5065

Is there any advantage to denormalizing DB2 tables?

1 6648

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

2 5387

What is sqlcode -922 ?

2 26409

What is lock escalation?

2 14375

What is the difference between primary key & unique index ?

Patni, Temenos,

6 27045

What is a DB2 bind?

3 7072

Post New DB2 Questions

Un-Answered Questions { DB2 }

Is db2 a mainframe database?

1000

What is a dbrm in db2?

1020

Explain about dbrm.

1047

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2045

How to connect to db2 database from windows command line?

1065

How do you stop a db2 database in linux?

1012

What is explain in db2?

1020

How can record locking be achieved in those DB2 versions which do not support it?

1076

Explain the contention situations caused by locks?

1070

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11673

Which isolation level provides maximum concurrency?

1152

What is package in db2 mainframe?

987

How can the duplicate values be eliminated from db2 select?

1106

Which component is used to execute the sql statements?

1096

What is database alias db2?

1125

For More Un-Answered { DB2 } Questions Click Here