C#

What is the difference between a property and a field in object-oriented programming?

What can a delegate contain in C#?

How is caching implemented in Entity Framework Core?

What is the 'set' method in C#?

What do you understand by tight coupling between objects?

Explain the concept of authorization in the context of information systems.

What data structures exist?

What is a virtual method in C#?

What problems can arise when working with multithreading and how can they be avoided?

What can be said about the query plan's optimality? MVCC There is a table CREATE TABLE orders ( id BIGSERIAL PRIMARY KEY, status TEXT, updated_at TIMESTAMP ); and a query running every second UPDATE orders SET status = 'processed', updated_at = now() WHERE id = 1; After a few days, you notice: • the table size has grown significantly • the query SELECT * FROM orders WHERE id = 1 runs slower Questions for the candidate: 1. Why does the table grow even though the row is always the same? 2. What role does MVCC play in this situation? 3. What should solve this problem?

What type of polymorphism is implemented when using generic types?

In what situations does the stack grow during program execution?

What types of joins are available in SQL?

Can we build an inheritance chain using abstract classes?

In which cases should you use an interface, and in which — an abstract class?

What naming rules for resources do you know in REST?

Explain the purpose of the GROUP BY operator in SQL and when it is used.

What libraries or tools based on C++ do you use in your projects?

What types of type casting exist in C#?

What methods ensure dependency injection in the code?