Querying interview questions

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

Answer + AI explanation with Pro

1. A.server evaluation
2. B.client evaluation
3. C.materialization
4. D.LINQ to Entities

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

1. A.server evaluation
2. B.materialization
3. C.client evaluation
4. D.IQueryable<T>

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

1. A.deferred execution
2. B.LINQ to Entities
3. C.materialization
4. D.client evaluation

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

1. A.client evaluation
2. B.IQueryable<T>
3. C.server evaluation
4. D.deferred execution

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

1. A.materialization
2. B.IQueryable<T>
3. C.client evaluation
4. D.deferred execution

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro

1. A.server evaluation
2. B.materialization
3. C.client evaluation
4. D.deferred execution

Answer + AI explanation with Pro

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

Answer + AI explanation with Pro