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 74596

What is an intent lock?

3 10812

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

1 4702

What is a synonym? How is it used?

2 5603

what is a collection?

2 5421

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

IBM,

1 13219

What are the disadvantages of using VARCHAR?

3 15643

What is the purpose of the DSNC transaction ?

1 7588

What are delete-connected tables?

1 4378

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

4 30351

What is a correlated sub query?

2 5464

What is read-only cursor?

1 6774

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

1 5845

What is Skeleton cursor table (SKCT)?

2 14450

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the use of dclgen in db2?

1085

Is schema the same as database?

1059

What is null indicator in cobol db2?

1067

Why db2 is called db2?

1041

How do I add a column to an existing table in db2?

1032

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1082

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2066

Which components manage deadlocks in db2?

1071

What are db2 tables?

1125

What is the difference between db2 and oracle?

1133

Which isolation level provides highest data integrity?

1118

What are catalog tables in db2?

1050

What is an instance database?

1052

How do I add a column to a table in db2?

1104

What is catalog database in db2?

1165

For More Un-Answered { DB2 } Questions Click Here