Sobes.tech

What is the role of a foreign key in a relational database?

Junior — Middle
349

What is the difference between using synchronizedMap and ConcurrentHashMap to ensure thread safety in collections?

Junior — Middle
308

What methods can be used to increase the query speed to a table that processes about 100,000 new records daily, and how will this affect weekly batch processing?

Middle — Middle+
302

By what other methods, besides multithreading, can the efficiency of a report-generating service that performs 4 parallel HTTP requests to different systems be increased?

Junior — Middle
288

How can you optimize or fix errors in an SQL query?

Junior — Middle
287

What are the time costs for performing maximum element search operations when using ArrayList, if elements are added infrequently?

Junior — Middle
283

How can a pessimistic locking mechanism be implemented to ensure data integrity in a multithreaded environment?

Middle — Middle+
282

What are the reasons in favor of limiting the number of indexable fields in a database?

Junior — Middle
272

Have you conducted metrics collection and analysis directly from servers in a production environment in your last project?

Junior — Middle
261

What is the difference between map and flatMap methods in Java Stream API and what are their usage features?

Junior — Middle
260

Explain the concept of full locking in database management and its features.

Junior — Middle
258

Have you used the SELECT statement in data update operations (UPDATE)?

Junior — Middle
257

What steps will you take to identify the causes of regular service restarts related to the OutOfMemoryError error?

Junior — Middle
255

What types of indexes exist in SQL database management systems?

Junior — Middle
254

What data structure is preferable for quickly retrieving the maximum element with rare insertions?

Junior — Middle
254
/15