SQL, Indexes & JPA
The database layer where performance is actually won or lost — isolation levels, index eligibility, pagination, JPA fetching and locking, and migrations that do not lock a live table.
Twenty questions on the layer where performance is usually won or lost:
isolation levels and what each actually prevents, when an index can and cannot
be used, why deep OFFSET degrades, JPA fetching and locking, and how to add an
index without locking a live table.
You get a score at the end, not a breakdown.
Leaderboard
…
Grading happens on the server, so this part needs a connection.
Taking the quiz needs an account, so the score is yours and can reach the leaderboard. Sign in with GitHub or Google — reading this page does not need it.
Sign in if you want your score on this board.