C#

What is the get method in C#?

Is it possible to use the await operation inside a critical section protected by a lock?

What is Dependency Injection used for?

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

How is caching implemented in Entity Framework Core?

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

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 libraries or tools based on C++ do you use in your projects?

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?

Is it possible to pass large data types by reference in a function?

What are the ways (protocols) of data exchange between a server and a client?

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.