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

DB2 Interview Questions

Questions Answers Views Company eMail

What information is used as input to the bind process?

2 7464

Can I use LOCK TABLE on a view?

1 6893

Are views updatable ?

4 12643

Give some example of statistics collected during RUNSTATS?

1 5877

What is referential integrity?

5 19944

What is EXPLAIN?

1 6196

What is a DB2 plan?

8 45427

How to define the data items to receive the fetch items for the SQL?

2 5944

What is a page?

2 5112

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

CTS,

1 10193

What is a collection?

3 6940

What does the CHECK Utility do ?

1 5663

Where could you look if you had a question about whether a column has been defined as an index?

2 5961

What are the various locking levels available?

3 6779

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

3 7454

Post New DB2 Questions

Un-Answered Questions { DB2 }

Define sqlca.

1119

What is isolation level in db2?

1015

How can deadlocks be resolved?

946

On which levels locks can be applied?

1144

What is sqlca’s maximum length?

1197

How do I delete a column in db2?

1113

What is cursor with hold option in db2?

1084

Which component is responsible for processing sql statements and selecting access paths?

1135

What is the difference between db2 and oracle?

1135

How to retrieve rows from a db2 table in embedded sql?

1398

What is role in db2?

1113

what is the sqlcode -501

13170

What action db2 takes when a program aborts in the middle of a transaction?

1156

How will you return the number of records in table?

944

What is the maximum number of columns in a db2 table?

1290

For More Un-Answered { DB2 } Questions Click Here