DeepFrontend
Learning Paths
Practice
System Design & DS
Design Studio
Data Structures Curriculum
Real-World Case Studies
Careers
Job Board
Resume Builder
Blog
Sign in
Search
⌘K
Go Pro
Loading compiler resources...
API Development Quiz Practice
Active Recall Drill Session
← Exit Session
Question 1 of 1
medium
API Development
What is the specific, demonstrated consistency bug in offset pagination?
A
It's slower than cursor pagination, nothing more
B
A row deleted (or inserted) between two paginated requests shifts subsequent row positions, causing a guaranteed skip or duplicate — not a rare edge case
C
It cannot be implemented in SQL at all
D
It only affects the first page of results
Check Answer