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.
104 results across 1 active filter
Page 4 of 5
Explains optimistic concurrency with EF Core rowversion tokens, API conflict responses, and safe retry boundaries.
Explains stale edit detection, row versioning, conflict UI, refresh behavior, and safe update contracts.
Explains why application-level duplicate checks are not enough and how EF Core APIs map database constraints to friendly errors.
Explains debounce, cancellation, stale-response protection, loading indicators, and backend query safety for search UI.
Explains stable EF Core pagination using cursor predicates, deterministic ordering, and index-aligned queries.
Explains how to inspect EF Core generated SQL and connect LINQ shape to database execution behavior.
Investigates a growing-data EF Core slowdown through one correlated request, generated SQL, representative parameters, execution plan, waits, query shape, measured repair, and guarded rollout.
Compares rollback, reset, schema, database, and tenant isolation without hiding transaction or parallelism limits.
Explains when LINQ is enough, when raw SQL is clearer, and how to keep raw SQL safe and maintainable.
Chooses between a modular monolith and microservices using domain boundaries, team ownership, scaling, deployment, data consistency, and operational cost.
Implements descending keyset pagination with a compound cursor and stable ordering.
Explains expand-and-contract migrations, backwards-compatible schema changes, backfills, rollout order, and rollback thinking.
Explains frontend guards, backend idempotency, pending state, retries, and duplicate-safe mutation design.
Explains EF Core projections for API read models that need related names, counts, and summaries without loading full graphs.
Converts local-day boundaries to UTC once, preserving correct daylight-saving behavior and index use on stored UTC timestamps.
Uses an actual execution plan, row-flow evidence, runtime measurements, and representative parameters to diagnose a slow query without guessing.
Repairs a workflow when a remote operation may have succeeded but local state, messages, and callbacks disagree.
Ranks duplicate import rows, previews the deletion set, and removes older copies with deterministic retention.
Uses a conditional update and transaction to prevent overselling while recording the reservation consistently.
Writes a left-join aggregate that keeps active customers with no paid orders and applies date filters without changing join semantics.
Uses ROW_NUMBER with a deterministic tie-breaker to return the complete latest status row per order.
Aggregates product sales and ranks independently inside each category with a deterministic top-N rule.
Reviews and stages destructive EF Core schema changes around live data, locks, mixed application versions, recovery, and rollback.
Shapes an API list from its contract and cardinality, projecting only required values while preserving authorization, stable pagination, bounded nesting, index support, and measurable query cost.