12 real Performance 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 compiled query?
Mid
A.the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save
B.a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
C.an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join
D.the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows
A.compiled query — the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save
B.compiled query — a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
C.compiled query — an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join
D.compiled query — the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows
5. Which term means: "an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join"?
A.split query — the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows
B.split query — the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save
C.split query — a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
D.split query — an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join
A.batching — a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
B.batching — the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save
C.batching — an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join
D.batching — the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows
11. Which term means: "the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows"?
A.ExecuteUpdate — the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save
B.ExecuteUpdate — a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
C.ExecuteUpdate — the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows
D.ExecuteUpdate — an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join
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.