The recruiter does not understand priorities, just says 'I need 300 candidates' — how to handle this?
Golang
Which features of PostgreSQL have you used extensively?
Provide an example of a case with SELECT FOR UPDATE where it can lead to a deadlock.
Tell about your latest technical experience, what tasks you did, what was more engaging?
How was PostgreSQL sharding implemented — what served as the router?
Why did you leave the company?
At what phase are you currently in technical interviews? Do you have offers?
Have you worked with virtualization?
The alias 'oi' in the query — which table is it taken from?
What is an empty interface (interface{} / any) in Go?
What will the program output? func a() { x := []int{} x = append(x, 0) x = append(x, 1) x = append(x, 2) y := append(x, 3) z := append(x, 4) fmt.Println(y, z) } func main() { a() }
Tell me about the message brokers you have worked with.
How would you rate yourself as a Golang developer? Are you currently middle, middle+, or senior?
Is 146% CPU in top possible and what does it mean?
You need to describe the library model. There are 3 entities: "Author", "Book", "Reader". Physically, there is only one book and it can only belong to one reader. You need to create tables for the library to account for this.
What JOIN is used by default when you just write JOIN? What types of JOINs exist?
How much experience do you have with Go?
Implement a function that takes []any and delta int. It should increase only the first occurrences of unique integers (int) by delta. Other types and repeated numbers should remain unchanged. The function should return the updated slice and two numbers: updated – how many unique numbers were changed, duplicates – how many numeric elements turned out to be duplicates func IncrementUniqueIntsInMixed(xs []any, delta int) ([]any, int, int) { // your code } // Example: xs := []any{1, "a", 5, "b", 1, 0, 5} u, d, s := IncrementUniqueIntsInMixed(xs, 3) // xs == []any{4, "a", 8, "b", 1, 3, 5} // u == 3 // unique numbers: 1, 5, 0 // d == 2 // repeated numbers: second 1, second 5
What is important to consider in a polling worker?
Why did you decide to leave your current job?