C#

How to implement the Saga pattern using SQL?

How does the automatic removal mechanism of unused objects in the program work?

Can you name the existing levels of transaction isolation in database management systems?.

Explain the principle of data normalization in an SQL database and why it is necessary.

What approaches should be used when writing code to facilitate its automated testing?

Have you used inheritance principle when working with Entity Framework in your projects?

Can you explain what is meant by the term 'lock' in the context of multithreaded programming?

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

Could you explain what a Mock is and in what cases it is used in testing?

Can you explain the use of the AsNoTracking method in Entity Framework?

Can you explain what inheritance means in object-oriented programming?

Can it be considered that dynamic memory in the heap is thread-safe when working in parallel with multiple threads?

Can you explain what is meant by a transaction in the context of SQL and how it functions?

In what cases can the use of indexes in SQL become ineffective or lead to their failure?

How many regions are allocated for dynamic memory allocation during program execution?

What is the purpose of using string concatenation operation?

What is the purpose of a non-clustered index in a SQL database?

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

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

Can you explain the principle of dependency inversion and its importance in software system design?