What is the goal of using the Dispose method in resource management?
Junior — Middle
256
C#
How long have you worked on the most exciting task at your previous job?
Junior — Middle
256
How are basic data types stored and mapped in memory in C#?
Junior — Middle
256
What is deferred execution in LINQ?
Middle
256
Explain the concept of string interning and why it is used in programming.
Junior — Middle
256
How to implement user redirection from mobile devices to a mobile subdomain (like VKontakte)?
Middle
256
Have you ever worked with using composite indexes in a database?
Junior — Middle
256
Which specific version of .NET Core have you used in your projects?
Junior — Middle
256
Can you name some structural design patterns used in programming?
Junior — Middle
256
Have you ever changed the garbage collector mode in your system?
Junior — Middle
256
How does dotnet understand that an IO operation has completed?
Middle
256
What are the sources from which the execution flow in a program is created?
Junior — Middle
256
What tools do you use to prevent conflicts when working with threads simultaneously?
Junior — Middle
256
SQL task: a) Get the name of the employee with the highest salary and the name of their department; b) Get a list of departments where the average salary is more than $1000.
Middle+
256
What task management tools do you usually use in your professional activity?
Junior — Middle
256
How does Redis ensure correct handling of concurrent commands from multiple clients?
Middle
256
Can you explain what the INotifyPropertyChanged interface is and in what situations it is used?
Junior — Middle
256
What factors and structures can reduce the performance of data insertion operations in a SQL table?
Junior — Middle
256
When is it appropriate to use anonymous functions in code?
Junior — Middle
256
What methods can be used to determine properties and parameters of objects in a database?
Junior — Middle
256