Twenty new quizzes are now available on AnyTest, with 400 questions and explanations. This collection focuses on small topics that are easy to overlook: how a heap handles replacement, why a SQL aggregate returns NULL, or what happens when an object is cloned.
Each quiz has a bank of 20 questions. An attempt draws 10, with a practice target of 8 correct answers. Use the explanations on the results page to understand the rule behind an answer, then try another selection.
Python and data tools: work through the edge cases
Compare heappushpop with heapreplace, explore signed Counter values, distinguish repeated local times with zoneinfo, and follow ExitStack cleanup order. The Pandas quiz focuses on merge_asof direction and tolerance; NumPy practice covers insertion boundaries and the meaning of sorter.
- Python heapq Quiz: heappushpop, heapreplace and Top-k
- Python Counter Quiz: Signed Counts and Multiset Operations
- Pandas merge_asof Quiz: Direction, Tolerance and Exact Matches
- Python zoneinfo Quiz: fold, UTC and Ambiguous Local Times
- NumPy searchsorted Quiz: side, sorter and Boundary Indices
- Python ExitStack Quiz: Callback Order, Ownership and Exceptions
SQL, JavaScript and command-line tools
Choose one row per group with PostgreSQL DISTINCT ON, distinguish subtotal NULLs with GROUPING, and read jsonb containment correctly. Other quizzes cover SQLite affinity, JavaScript cloning and property descriptors, jq filtering, and Git pathspec rules.
- PostgreSQL DISTINCT ON Quiz: Latest Rows and Deterministic Ordering
- PostgreSQL GROUPING SETS Quiz: Subtotals, NULLs and GROUPING Bits
- SQLite Type Affinity Quiz: Storage Classes, CAST and Comparisons
- Git Pathspec Quiz: glob, top, literal and exclude
- JavaScript structuredClone Quiz: Identity, Cycles and Transfer
- jq Quiz: map, select, empty and Missing Values
- PostgreSQL jsonb Quiz: Containment, Existence and JSON Null
- JavaScript Property Descriptors Quiz: writable, enumerable and configurable
Six more quizzes in German, Spanish and Russian
German: conditional calculations with SUMMENPRODUKT and the difference between Git's index and working tree.
- Excel SUMMENPRODUKT: Quiz zu Bedingungen und Gewichtungen
- Git restore: Quiz zu Index, Arbeitsverzeichnis und HEAD
Spanish: Python positional-only and keyword-only parameters, plus repeated query keys and encoding with URLSearchParams.
- Python: parámetros solo posicionales y solo por palabra clave
- JavaScript URLSearchParams: claves repetidas y codificación
Russian: Excel АГРЕГАТ with errors and hidden rows, and PostgreSQL FILTER for conditional aggregation.
- Excel АГРЕГАТ: ошибки, скрытые строки и параметр k
- PostgreSQL FILTER: условные агрегаты, NULL и HAVING
Choose a topic, not a whole syllabus
The collection contains 14 English, 2 German, 2 Spanish and 2 Russian quizzes. Questions use small examples and focused scenarios rather than attempting to cover an entire programming language or tool. These are original practice exercises, not official certification exams.
Start with a feature you use at work but would hesitate to explain. After the attempt, review the reasoning and compare the cases that behave differently.