placd.in

Querying interview questions

18 real Querying 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 LINQ to Entities?

Junior
  1. A.the step where database rows are read and turned into entity or projection objects in memory
  2. B.translating query logic into SQL so filtering and projection run inside the database before rows are returned
  3. C.the query approach where C# expressions are translated by the provider into SQL executed by the database
  4. D.the property whereby a query is not run when defined but only when its results are iterated or materialized
Reveal the answer + AI explanation — free account

3. Which statement is correct?

Junior
  1. A.LINQ to Entities — the query approach where C# expressions are translated by the provider into SQL executed by the database
  2. B.LINQ to Entities — the interface representing a query as an expression tree that the provider translates and runs on the server when enumerated
  3. C.LINQ to Entities — the step where database rows are read and turned into entity or projection objects in memory
  4. D.LINQ to Entities — translating query logic into SQL so filtering and projection run inside the database before rows are returned
Reveal the answer + AI explanation — free account

4. What is IQueryable<T>?

Mid
  1. A.the step where database rows are read and turned into entity or projection objects in memory
  2. B.the property whereby a query is not run when defined but only when its results are iterated or materialized
  3. C.the interface representing a query as an expression tree that the provider translates and runs on the server when enumerated
  4. D.translating query logic into SQL so filtering and projection run inside the database before rows are returned
Reveal the answer + AI explanation — free account

5. Which term means: "the interface representing a query as an expression tree that the provider translates and runs on the server when enumerated"?

Mid
  1. A.server evaluation
  2. B.materialization
  3. C.client evaluation
  4. D.IQueryable<T>
Reveal the answer + AI explanation — free account

6. Which statement is correct?

Mid
  1. A.IQueryable<T> — the property whereby a query is not run when defined but only when its results are iterated or materialized
  2. B.IQueryable<T> — the interface representing a query as an expression tree that the provider translates and runs on the server when enumerated
  3. C.IQueryable<T> — the step where database rows are read and turned into entity or projection objects in memory
  4. D.IQueryable<T> — translating query logic into SQL so filtering and projection run inside the database before rows are returned
Reveal the answer + AI explanation — free account

7. What is deferred execution?

Mid
  1. A.the step where database rows are read and turned into entity or projection objects in memory
  2. B.translating query logic into SQL so filtering and projection run inside the database before rows are returned
  3. C.the property whereby a query is not run when defined but only when its results are iterated or materialized
  4. D.the interface representing a query as an expression tree that the provider translates and runs on the server when enumerated
Reveal the answer + AI explanation — free account

8. Which term means: "the property whereby a query is not run when defined but only when its results are iterated or materialized"?

Mid
  1. A.deferred execution
  2. B.LINQ to Entities
  3. C.materialization
  4. D.client evaluation
Reveal the answer + AI explanation — free account

9. Which statement is correct?

Mid
  1. A.deferred execution — translating query logic into SQL so filtering and projection run inside the database before rows are returned
  2. B.deferred execution — the step where database rows are read and turned into entity or projection objects in memory
  3. C.deferred execution — the property whereby a query is not run when defined but only when its results are iterated or materialized
  4. D.deferred execution — the query approach where C# expressions are translated by the provider into SQL executed by the database
Reveal the answer + AI explanation — free account

10. What is server evaluation?

Senior
  1. A.the property whereby a query is not run when defined but only when its results are iterated or materialized
  2. B.translating query logic into SQL so filtering and projection run inside the database before rows are returned
  3. C.the query approach where C# expressions are translated by the provider into SQL executed by the database
  4. D.the interface representing a query as an expression tree that the provider translates and runs on the server when enumerated
Reveal the answer + AI explanation — free account

11. Which term means: "translating query logic into SQL so filtering and projection run inside the database before rows are returned"?

Senior
  1. A.client evaluation
  2. B.IQueryable<T>
  3. C.server evaluation
  4. D.deferred execution
Reveal the answer + AI explanation — free account

12. Which statement is correct?

Senior
  1. A.server evaluation — the query approach where C# expressions are translated by the provider into SQL executed by the database
  2. B.server evaluation — the interface representing a query as an expression tree that the provider translates and runs on the server when enumerated
  3. C.server evaluation — the step where database rows are read and turned into entity or projection objects in memory
  4. D.server evaluation — translating query logic into SQL so filtering and projection run inside the database before rows are returned
Reveal the answer + AI explanation — free account

13. What is client evaluation?

Senior
  1. A.the interface representing a query as an expression tree that the provider translates and runs on the server when enumerated
  2. B.the property whereby a query is not run when defined but only when its results are iterated or materialized
  3. C.the query approach where C# expressions are translated by the provider into SQL executed by the database
  4. D.running parts of a query in application memory after fetching rows, restricted in modern versions to the final projection to avoid silent inefficiency
Reveal the answer + AI explanation — free account

14. Which term means: "running parts of a query in application memory after fetching rows, restricted in modern versions to the final projection to avoid silent inefficiency"?

Senior
  1. A.materialization
  2. B.IQueryable<T>
  3. C.client evaluation
  4. D.deferred execution
Reveal the answer + AI explanation — free account

15. Which statement is correct?

Senior
  1. A.client evaluation — translating query logic into SQL so filtering and projection run inside the database before rows are returned
  2. B.client evaluation — the property whereby a query is not run when defined but only when its results are iterated or materialized
  3. C.client evaluation — running parts of a query in application memory after fetching rows, restricted in modern versions to the final projection to avoid silent inefficiency
  4. D.client evaluation — the step where database rows are read and turned into entity or projection objects in memory
Reveal the answer + AI explanation — free account

16. What is materialization?

Mid
  1. A.translating query logic into SQL so filtering and projection run inside the database before rows are returned
  2. B.the query approach where C# expressions are translated by the provider into SQL executed by the database
  3. C.the step where database rows are read and turned into entity or projection objects in memory
  4. D.the interface representing a query as an expression tree that the provider translates and runs on the server when enumerated
Reveal the answer + AI explanation — free account

18. Which statement is correct?

Mid
  1. A.materialization — the query approach where C# expressions are translated by the provider into SQL executed by the database
  2. B.materialization — the interface representing a query as an expression tree that the provider translates and runs on the server when enumerated
  3. C.materialization — the property whereby a query is not run when defined but only when its results are iterated or materialized
  4. D.materialization — the step where database rows are read and turned into entity or projection objects in memory
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 Querying free

More EF Core topics

DbContext & Sets (21)Modeling (21)Relationships (18)Loading Strategies (18)Change Tracking (21)Migrations (15)Performance (12)Concurrency (12)Transactions & Providers (12)