Sobes.tech

Have you had experience with RAG and vector search?

Senior
193

-- There are tables with the following structure Employee id (PK) name salary dep_id(FK department.id) Department id (PK) name -- write a query that returns a list of all department names with the maximum salary in each department select d.name, MAX(e.salary) from Employee e join Department d on e.dep_id = d.id group by d.name

Senior
193

What professional development do you plan for yourself in the future?

Junior — Middle
193

Why is it not allowed to make an HTTP request inside a database transaction?

Senior
193

What mechanisms need to be implemented in a Mission Critical system? How to achieve fault tolerance?

Senior
193

How do you monitor that the system is working correctly? What metrics and monitoring do you use?

Middle
193

What design patterns do you use? Why are they needed?

Senior
193

How convenient would it be to have a dedicated Scrum Master?

Senior
193

How to implement rate limiting for an external API with RPS restrictions? How do virtual threads/coroutines differ from system threads?

193

What situations or circumstances can decrease your motivation at work?

Junior — Middle
193

All beans are singletons. Many requests arrive at the same REST method. How is thread safety ensured? Does Spring guarantee anything out of the box?

193

How to check that lists are equal in content, but order does not matter? List<String> actual = List.of("B", "A", "C"); List<String> expected = List.of("A", "B", "C");

Middle
193

What are optimistic and pessimistic locking? How to implement them?

193

How do hash indexes differ from B-tree indexes? Which is preferable for searching by last names?

193

What is the fork system call in Unix-like operating systems?

Senior
192

public class ClassA { int a; @Override public boolean equals(Object obj) { //implementation if (this == obj) return true; if (!(obj instanceof ClassA)) return false; ClassA other = (ClassA) obj; return this.a == other.a; } } public class ClassB extends ClassA { int b; @Override public boolean equals(Object obj) { //implementation if (this == obj) return true; if (!(obj instanceof ClassB)) return false; if (!super.equals(obj)) return false; ClassB other = (ClassB) obj; return this.b == other.b; } } ClassB b1 = new ClassB(10, 20); ClassB b2 = new ClassB(10, 20); assertTrue(b1.equals(b2));

Senior
192
/740