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 9257

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

1 13593

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 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 7155

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

4 6921

What is the purpose of the WHENEVER statement?

1 5065

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 26415

What is lock escalation?

2 14375

What is the difference between primary key & unique index ?

Patni, Temenos,

6 27046

What is a DB2 bind?

3 7073

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do I copy a table in db2?

1000

What happens in bind step in a db2 program?

974

How is a typical db2 batch pgm executed?

1176

How can deadlocks be resolved?

937

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1071

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1148

What is cobol db2?

1001

What is db2?

1182

How will you return the number of records in table?

937

What is the difference between spufi and qmf?

1132

What type of database is db2?

971

How many databases can be created inside an instance in db2 ?

1035

What are the uses of db2 optimizer?

1296

How does coalesce work?

1021

What are the contents of a dclmgen?

1128

For More Un-Answered { DB2 } Questions Click Here