← Quiz: Unique ID Generator: all 15 questions
Quiz: Unique ID Generator · Question 4 of 15
What is the main drawback of random UUID v4 as the primary key of a very large, insert-heavy table?
What is the main drawback of random UUID v4 as the primary key of a very large, insert-heavy table?
- A.They often collide
- B.They are 128-bit and random, so inserts land all over the index instead of at the end
- C.They cannot be generated without a central server
- D.They only work in Java
Answer & explanation
Correct answer: They are 128-bit and random, so inserts land all over the index instead of at the end
Random keys spread inserts across the whole B-tree index; time-ordered keys append at the end.
Can you get the rest right without peeking?
Take the timed Quiz: Unique ID Generator quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →