"Paging: OFFSET/FETCH vs Keyset"

1. What is a significant disadvantage of using OFFSET/FETCH for deep paging?

It requires an additional index. It costs O(n) to export through every page. It allows jumping directly to any arbitrary page. It doesn't require unique tiebreakers.

2. What is the primary mechanism that keyset pagination uses to find rows?

It skips a given number of rows before fetching data. It uses the last row's key values to filter results. It scans the entire result set. It ensures an arbitrary ORDER BY clause is used.

3. Why is it essential to append a unique tiebreaker in the ORDER BY clause when using OFFSET/FETCH?

To make the query more readable. To ensure the rows are grouped correctly. To avoid rows appearing on two pages or missing altogether. To optimize resource usage.

4. Which statement describes a key advantage of keyset pagination over OFFSET/FETCH?

Keyset pagination allows for jumping to any page. Keyset pagination can handle non-deterministic ordering. The cost remains constant regardless of page depth. Keyset pagination always requires a full result set scan.

Continue: "Blocking, RCSI, and Why NOLOCK Is the Wrong Fix" → Review this lesson Retake quiz