Mention the downsides of page level lock.
No Answer is Posted For this Question
Be the First to Post Answer
cobol-db2 runjcl please?
What is the maximum No of rows per page?
If I have a view which is a join of two or more tables, can this view be updatable?
What are the two types of logging in the db2 database? Explain them.
What is the difference between TYPE 1 index & TYPE 2 index
How to take backup of table in db2?
Mention data types used in db2 ?
what is the role of the cursor in db2?
Name the various locking levels available?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What is nvl in db2?
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?