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 6157

What is sqlcode -811?

Accenture, CTS, TCS,

7 74176

What is an intent lock?

3 10640

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

1 4606

What is a synonym? How is it used?

2 5471

what is a collection?

2 5269

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

IBM,

1 13111

What are the disadvantages of using VARCHAR?

3 15419

What is the purpose of the DSNC transaction ?

1 7457

What are delete-connected tables?

1 4286

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

4 30104

What is a correlated sub query?

2 5329

What is read-only cursor?

1 6670

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

1 5729

What is Skeleton cursor table (SKCT)?

2 14277

Post New DB2 Questions

Un-Answered Questions { DB2 }

Who uses db2?

985

If I have a view which is a join of two or more tables, can this view be updateable?

1086

Why select is not preferred in embedded sql programs?

1232

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1007

What is the difference between cursor and select statement?

1056

What is the role of schema in the db2 database?

1183

How is the value function used?

1081

Why do chiropractors use drop table?

1046

Can you tell me how can you find out the # of rows updated after an update statement?

1046

What is table space in db2?

963

What is cloudant database?

1034

What is a bind in db2?

985

How to find schema of a table in db2?

953

What is buffer pool in the db2 database?

1047

What does runstats do in db2?

1025

For More Un-Answered { DB2 } Questions Click Here