Sobes.tech

How to implement element search by key with a time complexity of O(n)?

Junior — Middle
237

How do reference types differ from value types, and how does this affect working with them?

Junior — Middle
236

Can you list the main types of joins in SQL and briefly explain their purpose?

Junior — Middle
236

Can you explain what VACUUM FULL command means in SQL and how it differs from the regular VACUUM?

Junior — Middle
236

Can you explain the difference between stack and heap in memory management?

Junior — Middle
235

Can asynchronous processes run simultaneously without a queue?

Junior — Middle
232

Can you explain the concept of a synchronization context and its role in thread management?

Junior — Middle
231

Where is an integer field usually placed in a class object?

Junior — Middle
231

Explain the differences between using WHERE and HAVING in SQL queries and when to prefer each.

Junior — Middle
230

Why is a stack needed? Why not store all data in the heap?

Middle
227

What data type should the argument of the Equals method have?

Junior — Middle
225

What factors influence the implementation of asynchronous operations in a system?

Junior — Middle
224

Is it possible to run multiple asynchronous tasks simultaneously to increase efficiency?

Junior — Middle
223

How can you continue executing an asynchronous function after it is interrupted or when work resumes?

Junior — Middle
221

What is the main function of a stack in programming and in what cases is it used?

Junior — Middle
221

Can you explain what a HashSet data structure is and what it is used for?

Junior — Middle
219

What steps will you take if you notice a decrease in system performance in a production environment?

Junior — Middle
219
/8