Loading Strategies interview questions

18 real Loading Strategies questions from the EF Core bank, as asked in Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd — free to start.

1. What is eager loading?

Junior
  1. A.fetching related data automatically on first access to a navigation, requiring proxies and risking many small extra queries
  2. B.pulling related data in the same query using Include so navigations are populated up front
  3. C.the operator that continues eager loading into a navigation of an already-included related entity
  4. D.the inefficiency where iterating a parent list issues one extra query per item to fetch its related rows, often caused by lazy loading
Reveal the answer + AI explanation — free account

3. Which statement is correct?

Junior
  1. A.eager loading — the ability to apply Where and ordering inside an Include so only a subset of related rows is loaded
  2. B.eager loading — manually triggering retrieval of a related navigation after the parent is loaded, via Entry with Reference or Collection
  3. C.eager loading — pulling related data in the same query using Include so navigations are populated up front
  4. D.eager loading — the operator that continues eager loading into a navigation of an already-included related entity
Reveal the answer + AI explanation — free account

4. What is lazy loading?

Mid
  1. A.manually triggering retrieval of a related navigation after the parent is loaded, via Entry with Reference or Collection
  2. B.the ability to apply Where and ordering inside an Include so only a subset of related rows is loaded
  3. C.pulling related data in the same query using Include so navigations are populated up front
  4. D.fetching related data automatically on first access to a navigation, requiring proxies and risking many small extra queries
Reveal the answer + AI explanation — free account

5. Which term means: "fetching related data automatically on first access to a navigation, requiring proxies and risking many small extra queries"?

Mid
  1. A.lazy loading
  2. B.N+1 problem
  3. C.ThenInclude
  4. D.explicit loading
Reveal the answer + AI explanation — free account

6. Which statement is correct?

Mid
  1. A.lazy loading — the operator that continues eager loading into a navigation of an already-included related entity
  2. B.lazy loading — fetching related data automatically on first access to a navigation, requiring proxies and risking many small extra queries
  3. C.lazy loading — the ability to apply Where and ordering inside an Include so only a subset of related rows is loaded
  4. D.lazy loading — manually triggering retrieval of a related navigation after the parent is loaded, via Entry with Reference or Collection
Reveal the answer + AI explanation — free account

7. What is explicit loading?

Mid
  1. A.the inefficiency where iterating a parent list issues one extra query per item to fetch its related rows, often caused by lazy loading
  2. B.manually triggering retrieval of a related navigation after the parent is loaded, via Entry with Reference or Collection
  3. C.the ability to apply Where and ordering inside an Include so only a subset of related rows is loaded
  4. D.fetching related data automatically on first access to a navigation, requiring proxies and risking many small extra queries
Reveal the answer + AI explanation — free account

8. Which term means: "manually triggering retrieval of a related navigation after the parent is loaded, via Entry with Reference or Collection"?

Mid
  1. A.filtered include
  2. B.explicit loading
  3. C.ThenInclude
  4. D.lazy loading
Reveal the answer + AI explanation — free account

9. Which statement is correct?

Mid
  1. A.explicit loading — manually triggering retrieval of a related navigation after the parent is loaded, via Entry with Reference or Collection
  2. B.explicit loading — the operator that continues eager loading into a navigation of an already-included related entity
  3. C.explicit loading — fetching related data automatically on first access to a navigation, requiring proxies and risking many small extra queries
  4. D.explicit loading — the inefficiency where iterating a parent list issues one extra query per item to fetch its related rows, often caused by lazy loading
Reveal the answer + AI explanation — free account

10. What is N+1 problem?

Junior
  1. A.the ability to apply Where and ordering inside an Include so only a subset of related rows is loaded
  2. B.pulling related data in the same query using Include so navigations are populated up front
  3. C.the inefficiency where iterating a parent list issues one extra query per item to fetch its related rows, often caused by lazy loading
  4. D.manually triggering retrieval of a related navigation after the parent is loaded, via Entry with Reference or Collection
Reveal the answer + AI explanation — free account

11. Which term means: "the inefficiency where iterating a parent list issues one extra query per item to fetch its related rows, often caused by lazy loading"?

Junior
  1. A.N+1 problem
  2. B.lazy loading
  3. C.explicit loading
  4. D.eager loading
Reveal the answer + AI explanation — free account

12. Which statement is correct?

Junior
  1. A.N+1 problem — fetching related data automatically on first access to a navigation, requiring proxies and risking many small extra queries
  2. B.N+1 problem — pulling related data in the same query using Include so navigations are populated up front
  3. C.N+1 problem — the inefficiency where iterating a parent list issues one extra query per item to fetch its related rows, often caused by lazy loading
  4. D.N+1 problem — manually triggering retrieval of a related navigation after the parent is loaded, via Entry with Reference or Collection
Reveal the answer + AI explanation — free account

13. What is ThenInclude?

Senior
  1. A.the ability to apply Where and ordering inside an Include so only a subset of related rows is loaded
  2. B.fetching related data automatically on first access to a navigation, requiring proxies and risking many small extra queries
  3. C.the operator that continues eager loading into a navigation of an already-included related entity
  4. D.manually triggering retrieval of a related navigation after the parent is loaded, via Entry with Reference or Collection
Reveal the answer + AI explanation — free account

15. Which statement is correct?

Senior
  1. A.ThenInclude — the inefficiency where iterating a parent list issues one extra query per item to fetch its related rows, often caused by lazy loading
  2. B.ThenInclude — fetching related data automatically on first access to a navigation, requiring proxies and risking many small extra queries
  3. C.ThenInclude — the operator that continues eager loading into a navigation of an already-included related entity
  4. D.ThenInclude — manually triggering retrieval of a related navigation after the parent is loaded, via Entry with Reference or Collection
Reveal the answer + AI explanation — free account

16. What is filtered include?

Senior
  1. A.the operator that continues eager loading into a navigation of an already-included related entity
  2. B.pulling related data in the same query using Include so navigations are populated up front
  3. C.the ability to apply Where and ordering inside an Include so only a subset of related rows is loaded
  4. D.fetching related data automatically on first access to a navigation, requiring proxies and risking many small extra queries
Reveal the answer + AI explanation — free account

18. Which statement is correct?

Senior
  1. A.filtered include — fetching related data automatically on first access to a navigation, requiring proxies and risking many small extra queries
  2. B.filtered include — the inefficiency where iterating a parent list issues one extra query per item to fetch its related rows, often caused by lazy loading
  3. C.filtered include — the operator that continues eager loading into a navigation of an already-included related entity
  4. D.filtered include — the ability to apply Where and ordering inside an Include so only a subset of related rows is loaded
Reveal the answer + AI explanation — free account

Free to start

Answers, AI explanations, and a scored voice mock interview

Sign up free to check your answers with explanations, ask the AI tutor anything on any question, and take one full AI mock interview — scored like a real panel.

Practice Loading Strategies free