C#

How to add a third-party library to a project?

What difficulties may arise when implementing the Singleton pattern in a multithreaded environment?

In what form and format were messages implemented in RabbitMQ at your previous workplace?

What data types are permissible as keys when working with dictionaries?

What is the main purpose of using containerization with Docker?

Where is the class definition usually stored in programming?

Junior — Middle

IT One

Describe the approach used in creating and configuring a customer relationship management system.

How is memory allocated for list elements?

What methods or tools have you used to request data from servers via the HTTP protocol?

Task 3 Given the following SQL database structure --Table Departments create table D ( Id int primary key, Name nvarchar(100), ) --Table Employees create table E ( Id int primary key, DepartmentId int foreign key references Departments(Id), Name nvarchar(100), Salary float, ) Required: a. Write a query to get the name of one employee with the highest salary in the company and the name of their department b. Get a list of departments where the average salary is more than $1000

Middle+

Pyrus

Can you list and describe the methods implemented in the IEnumerator interface?

Junior — Middle

Aston

Can you explain what is meant by essential data types in programming?

What are lambda expressions in C#?

What are the main advantages and disadvantages of using microservice architecture?

Junior — Middle

OZON

Is it possible to instantiate an abstract class directly in the code?

Is it possible to extend a class by adding a constructor with arguments?

What are the advantages and disadvantages of using asynchronous approaches in programming?

How do you diagnose and fix the causes of low SQL query performance?

What key qualities and skills should an effective team lead have?

Provide an example of code execution that returns an object of the IQueryable interface.