C#

What are the advantages and disadvantages of using the Include directive in your project?

What is the purpose of using string concatenation operation?

Explain what the INCLUDE operator in SQL is and how it is used in queries.

What strategies can be applied to improve the efficiency of query execution in Entity Framework?

Is it necessary to implement a state machine when not using async/await?

How can the transaction isolation level be configured in a database?

Explain what the term NULL means in the context of database logs.

Explain what a single thread of execution in a program is and how it works.

Can you explain what is meant by indexes in the context of SQL databases?

Junior — Middle

ПочтатехЭлисофтOZON+1

What are the main recommendations and limitations when creating indexes in SQL systems?

Can you explain what a discriminator is in the context of Entity Framework and how it is used with tables containing hierarchical data?

Can you explain the concept of Boxing in the context of programming languages?

Junior — Middle

ЭлисофтOZON

Can you explain the concept of bit flags in SQL and how they are used to store multiple boolean values in a single column?

Can you explain the mechanism of lock escalation in SQL database management systems?

Does the garbage collector have the ability to clear all generations in any situation?