Pick a focused question that fits your time, stack, and interview goal.
How much time do you have?
Show one-drill sessions you can finish now.
1345 results
Page 15 of 57
Explains how statistics and cardinality estimates affect plan choice, joins, memory grants, and slow queries.
Explains how an HTTP request flows through ASP.NET Core middleware, routing, endpoint execution, and response generation.
Connects JavaScript tasks and microtasks to rendering, responsiveness, and practical performance fixes.
Explains why exactly-once claims do not remove the need for idempotent side effects and consistency boundaries.
Explains what useEffect is for, how dependencies work, and how to avoid stale or runaway effects.
Explains what CORS controls, what it does not protect, and why APIs still need authentication and authorization.
Explains static extension binding, instance-member precedence, namespace ambiguity, null receivers, and compatibility when APIs evolve.
Manages feature flags as temporary production controls with ownership, safe defaults, targeted rollout, telemetry, audit, failure behavior, and planned removal.
Implements bounded asyncio HTTP concurrency with one client, per-call deadlines, TaskGroup ownership, and deterministic cleanup.
Explains filtered Include in EF Core with practical .NET data-access examples and production trade-offs.
Uses EXISTS instead of a row-multiplying join when the related table is only a filter.
Groups normalized email values to identify duplicates before adding or repairing a uniqueness rule.
Uses the gaps-and-islands pattern to find consecutive login-day streaks after deduplicating same-day activity.
Solves a many-to-many all-match filter with grouping and a deliberate empty-selection rule.
Implements a stable first-unique-character search using counts and original order.
Uses NOT EXISTS to express an anti-join without null traps or duplicate parent rows.
Explain why starting background work without awaiting or tracking it is risky in ASP.NET Core applications.
Repairs a Django serialization path with select_related and prefetch_related, then locks the query shape with a regression test.
Uses a bounded entity graph for a to-one association and proves the repair with Hibernate query statistics.
Explains why cached authorization decisions are risky and how to bound or invalidate permission-related cache safely.
Moves non-deterministic browser-only rendering behind a stable server snapshot and post-hydration update.
Repairs a stale view by bringing an external callback into explicit Angular state ownership without adding polling or global change detection.
Flattens a tree into display paths while preserving order and preventing simple cycles.
Uses a recursive CTE to return hierarchy depth and a readable root-to-node path.