Mention the downsides of page level lock.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

cobol-db2 runjcl please?

2 Answers   DELL,


What is the maximum No of rows per page?

0 Answers   IBM,


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

3 Answers  


What are the two types of logging in the db2 database? Explain them.

0 Answers  


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

1 Answers   IBM,






How to take backup of table in db2?

0 Answers  


Mention data types used in db2 ?

0 Answers  


what is the role of the cursor in db2?

0 Answers  


Name the various locking levels available?

0 Answers  


DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,


What is nvl in db2?

0 Answers  


If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  


Categories