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 6632

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 5056

What is a DB2 catalog?

2 7046

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

4 6744

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 5240

What is sqlcode -922 ?

2 26222

What is lock escalation?

2 14230

What is the difference between primary key & unique index ?

Patni, Temenos,

6 26748

What is a DB2 bind?

3 6915

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the usage of open cursor command?

1040

What is role in db2?

1042

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

1103

Define db2.

1067

Explain package in db2 and its advantages?

1139

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

1977

Mention the definition of cobol in varchar field.

1181

What is null in db2?

950

Explain about rct.

1026

How does cobol compile db2 program?

1008

How do I delete a table in database?

977

What is buffer pool?

1033

Mention the downsides of page level lock.

1113

What is declare cursor?

1046

Why do chiropractors use drop table?

1047

For More Un-Answered { DB2 } Questions Click Here