Interview Q&A

Master technical and career interviews with structured answers—short definition, real examples, pitfalls, and how to answer in 60–90 seconds.

4608 total questions 4508 technical 100 career & HR 4272 from PDF library

Showing 51–54 of 54

Career & HR topics

By tech stack

Junior PDF
What is optimistic concurrency? How to implement it?

Short answer: Assumes conflicts are rare; detects conflicts when saving. Uses concurrency tokens (e.g., timestamp or row version) to detect if data was changed by another process. Say this in the interview Define — one c…

EF Core Read answer
Junior PDF
What is optimistic concurrency?

Short answer: How to implement it? Assumes conflicts are rare; detects conflicts when saving. Uses concurrency tokens (e.g., timestamp or row version) to detect if data was changed by another process. EF Core throws DbUp…

EF Core Read answer
Junior PDF
What is lazy loading proxy?

Short answer: EF Core creates a dynamic proxy subclass of your entity at runtime. Proxy overrides virtual navigation properties to load related data on-demand. Requires navigation properties to be virtual and package Mic…

EF Core Read answer
Junior PDF
What is lazy loading proxy?

Short answer: How does the dynamic proxy work under the hood? EF Core creates a dynamic proxy subclass of your entity at runtime. Proxy overrides virtual navigation properties to load related data on-demand. Requires nav…

EF Core Read answer

Entity Framework Core Entity Framework Core Tutorial · EF Core

Short answer: Assumes conflicts are rare; detects conflicts when saving. Uses concurrency tokens (e.g., timestamp or row version) to detect if data was changed by another process.

Say this in the interview

  1. Define — one clear sentence (the short answer above).
  2. Example — relate it to a project like ShopNest or your real work.
  3. Trade-off — when you would not use it.
Permalink & share

Entity Framework Core Entity Framework Core Tutorial · EF Core

Short answer: How to implement it? Assumes conflicts are rare; detects conflicts when saving. Uses concurrency tokens (e.g., timestamp or row version) to detect if data was changed by another process. EF Core throws DbUpdateConcurrencyException if a conflict occurs.

Say this in the interview

  1. Define — one clear sentence (the short answer above).
  2. Example — relate it to a project like ShopNest or your real work.
  3. Trade-off — when you would not use it.
Permalink & share

Entity Framework Core Entity Framework Core Tutorial · EF Core

Short answer: EF Core creates a dynamic proxy subclass of your entity at runtime. Proxy overrides virtual navigation properties to load related data on-demand. Requires navigation properties to be virtual and package Microsoft.EntityFrameworkCore.Proxies. Proxy intercepts access and triggers loading when property is accessed.

Real-world example (ShopNest)

Loading orders with items uses .Include(o => o.Items). Without Include, listing 50 orders can trigger 50 extra queries (N+1).

Say this in the interview

  1. Define — one clear sentence (the short answer above).
  2. Example — relate it to a project like ShopNest or your real work.
  3. Trade-off — when you would not use it.
Permalink & share

Entity Framework Core Entity Framework Core Tutorial · EF Core

Short answer: How does the dynamic proxy work under the hood? EF Core creates a dynamic proxy subclass of your entity at runtime. Proxy overrides virtual navigation properties to load related data on-demand. Requires navigation properties to be virtual and package Microsoft.EntityFrameworkCore.Proxies. Proxy intercepts access and triggers loading when property is accessed.

Real-world example (ShopNest)

Loading orders with items uses .Include(o => o.Items). Without Include, listing 50 orders can trigger 50 extra queries (N+1).

Say this in the interview

  1. Define — one clear sentence (the short answer above).
  2. Example — relate it to a project like ShopNest or your real work.
  3. Trade-off — when you would not use it.
Permalink & share
Toolliyo Assistant
Ask about tutorials, ebooks, training, pricing, mentor services, and support. I use public site content only—not admin or internal tools.

care@toolliyo.com

Need callback? Share your details