Correct Answer: It is based on the lock-size given while creating the tablespace
Explanation:
Note: This Question is unanswered, help us to find answer for this one
DB2 Administration Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More DB2 Administration MCQ Questions
What is a DB2 bind?
Which is not true for a segmented table space?
When is the access path determined for dynamic SQL?
If a user accidentally drops a table and commits work, which of the following recovers the dropped table?
How many clustering indexes can be defined for a table?
When working with concurrency controls, what happens when the number of locks held on rows and tables is equal to the percentage of the locklist specified by maxlocks?
Why is the deadlock detector an important part of DB2 architecture?
Given the code: EXEC SQL DECLARE cursor1 CURSOR FOR SELECT name, age, b_date FROM person; EXEC SQL OPEN cursor1; Under which of the following situations will the above cursor be implicitly closed?
Why is a primary key needed on a table?
Is the autorestart parameter configurable on-line?