Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?

C2090-320 1 Comment

Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?
A . PAGE
B . TABLE
C . PARTITION
D . TABLESPACE

Answer: C

Latest C2090-320 Dumps Valid Version with 123 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Instant Download C2090-320 PDF     C2090-320 Questions Online Training
Subscribe
Notify of
guest
1 Comment
Inline Feedbacks
View all comments
Aanchal Sahu
Aanchal Sahu
3 years ago

can you please explain the reason for this? As per my knowledge it should escalate to table level and not partition since it is a non partitioned table space.

0
Reply