DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What is a view? Why use it?

3 6301

What is sqlcode -811?

Accenture, CTS, TCS,

7 74589

What is an intent lock?

3 10811

what types of copies can be made with the COPY Utility ?

1 4698

What is a synonym? How is it used?

2 5603

what is a collection?

2 5418

What is the difference between TYPE 1 index & TYPE 2 index

IBM,

1 13219

What are the disadvantages of using VARCHAR?

3 15641

What is the purpose of the DSNC transaction ?

1 7586

What are delete-connected tables?

1 4378

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 30342

What is a correlated sub query?

2 5463

What is read-only cursor?

1 6774

What Utility is used to migrate DB2 from one release to the next?

1 5840

What is Skeleton cursor table (SKCT)?

2 14443

Post New DB2 Questions

Un-Answered Questions { DB2 }

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2248

How do you select a row using indexes in db2?

1135

What does db2 stand for?

1025

Mention some fields that are a part of sqlca.

1033

What is host variable in db2 cobol?

1077

What are iseries servers?

1075

What is dpf in db2?

1109

What is difference between alias and synonym in db2?

1141

What is the function of logging in the db2 database?

1121

What does sqlcabc has?

1054

What is the use of dclgen in db2?

1085

What is cascading rollback?

1214

Is db2 a mainframe database?

1000

How to create backup table in db2?

1090

what is the sqlcode -501

13150

For More Un-Answered { DB2 } Questions Click Here