Why did you decide to look for a new job and why did you leave your previous employer?
What financial range are you considering for proposals?
There is a table Clients and a table Orders, which can be linked through the ClientId field. What JOINs should be written to obtain the following results? a. Records of all clients and orders, regardless of whether clients have orders select * from Clients left join Orders on Clients.ClientId = Orders.ClientId d. Records only about those clients and orders if clients have orders select * from Clients inner join Orders on Clients.ClientId = Orders.ClientId
What is IDisposable used for? What does the 'using' keyword do?
SelectyCan you manually trigger garbage collection? How many generations does GC have and what other memory areas do you know?
Tell me more about the current project: at what stage it was, when you joined, what stage it is now, and what your role in the team is.
What synchronization primitives do you know in .NET and what are they used for?
SelectyHow to make a POST request when clicking on an HTML link?
Create a webpage with three paragraphs. Apply different margin styles to each paragraph using CSS classes: - The first paragraph should have margins of 20px top, 15px right, 5px bottom, and 10px left. - The second paragraph should have margins of 20px top and bottom, and 5px right and 10px left. - The third paragraph should have margins of 5px top and bottom, and 10px right and left.
// slice for all sensors, only the latest value by time // collection of anonymous objects, string double var result = list.GroupBy(x => x.Name) .Select(x => new { Name = x.Key, Value = x.OrderByDescending(g => g.Date).First().Value });
Tell about the most significant success or failure in your work experience.
SelectyWhen does the mandatory health insurance (DMS) start to be effective?
Which REST API HTTP methods are idempotent? Is it possible to send requests/data in GET and what are the limitations? How do the 4xx and 5xx status code families differ?
What fault-tolerance patterns do you know?
What is the difference between IEnumerable and IQueryable?
What is IQueryable and when is the query executed?
Do you understand JOIN, grouping, and aggregate functions in SQL?
Are you familiar with SOAP?
How does Redis ensure correct handling of concurrent commands from multiple clients?
Альфа-БанкWhat do HTTP status codes 200, 400, and 500 indicate?