Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Ibm Discussions
exam questions

Exam C2090-320 All Questions

View all questions & answers for the C2090-320 exam
Go to Exam

Exam C2090-320 topic 1 question 1 discussion

Actual exam question from IBM's C2090-320
Question #: 1
Topic #: 1
[All C2090-320 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by TeranceCambel at March 14, 2022, 8:02 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
aggoy1
1 month ago
It would be B Table lock..from Row and Page it will escalate to Table level for non-part tablespaces
upvoted 1 times
...
willyunger
2 years, 7 months ago
Believe escalation is always to TS, even if you have the old TS with many tables in it, hence the recommendation to LOCK TABLE if you anticipate need to use many locks. Can be granular to PARTITION (not the case in this example) Rgds
upvoted 1 times
...
TeranceCambel
2 years, 8 months ago
For non-partitioned table it will Table Lock. Answer is B.
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel