Sobes.tech

How are atomic operations with variables implemented and work in a multithreaded environment?

249

What are the advantages and disadvantages of using TestNG together with Selenium for test automation?

Junior — Middle
249

What is the difference between a standard hash table and a thread-safe implementation like ConcurrentHashMap?

Junior — Middle
249

Explain the Fail-fast principle and its role in software development

Junior — Middle
249

How do the annotations @Component, @Service, and @Repository differ in the context of Spring, and what are their features?

Junior — Middle
249

What information is stored in the stack data structure and how is it organized?

Junior — Middle
249

What is the difference between logging systems and tracing tools for distributed systems like OpenTelemetry?

Junior — Middle
249

What limitations exist in the PostgreSQL database management system?

Junior — Middle
249

What internal elements of objects do you use to implement business logic and processes?

Junior — Middle
249

Can you name and explain other common design patterns besides Singleton and Factory?

Junior — Middle
249

Does HashMap provide instant access to elements by value in all cases?

Junior — Middle
249

What is the difference between primitive data types in the context of strictly typed and statically typed systems?

Junior — Middle
248

How is error handling and exception management implemented in the program?

Junior — Middle
248

How was the workflow structured and distributed in your last project team?

Junior — Middle
248

What is a foreign key and how is it used to ensure data integrity between tables?

Junior — Middle
248

How is the @PostConstruct annotation used in Spring for component initialization?

Junior — Middle
248

What is the main problem with this implementation SELECT f.food_id FROM Foods f JOIN Expirations e ON f.id = e.food_id WHERE e.is_expired = 1; - Using `JOIN` instead of `WHERE EXISTS` to check for record existence. - No index on the e.is_expired field - JOIN keys are not indexed - The Expirations table is redundant - The query is not protected within a transaction.

248
/739