Sobes.tech

Describe the main goal of isolating changes in separate branches before merging into main: - To eliminate the need for testing before release - To ensure independent versions of the application for production and development without merge - To maintain the stability of the main branch - To avoid conflicts during collaborative development

Intern
176

What is the difference between a subquery in WHERE id IN (SELECT ...) and a subquery with WHERE EXISTS (SELECT ...)? IN compares values with a result set, EXISTS checks for the existence of at least one row IN is executed for each row of the outer query, EXISTS once No difference IN works only with numbers, EXISTS with any types

Intern
174

If you run git add only for some of the changed files, what exactly will be included in the commit when you run git commit -m? Files specified in git add, entirely with their current state, including unstaged changes All changes in all modified files, even those not added to the index Only the most recently modified files from the working directory Only the changes added to the index

Intern
174

What will the program output when executed? package main import "fmt" func main() { s := make([]int, 0, 3) m := map[string]int{"a": 1, "b": 2} for i := 0; i < 5; i++ { s = append(s, i) } fmt.Println(len(s), cap(s)) if v, ok := m["c"]; ok { fmt.Println(v) } else { fmt.Println("no key") } }

Intern
174

What are sockets and what types are there?.

Senior
172

Tell me how you develop and learn, what are you studying now?

Senior
172

What types of indexes are there in a database and what are they used for?

Senior
171

What is OLAP and OLTP?

Senior
171

What is idempotency in service requests?

Senior
171

What application layer protocols operate over TCP and UDP?

Senior
170

What does 'B' in B-tree mean?

Senior
170

What does the garbage collector (GC) in Go do, and when does it usually turn on automatically? It frees memory of unreachable objects and runs automatically when the heap size exceeds the runtime threshold. It arranges variable placement in memory for cache optimization and triggers strictly on a timer every 10 ms. It tracks the number of goroutines and only activates after the main function finishes. It synchronizes mutex operations and activates when free RAM drops below 5%.

Intern
169

How do you argue your point of view if a colleague disagrees with you?

Senior
168

Are you currently actively or passively looking for a job? Why are you looking for a new job?

Senior
168

What is a data race?

Senior
167

Tell me about your current job — what size of tasks do you take on?

Senior
167

What do you base your decision on when taking a risky decision in favor of speed or quality?

Senior
167

Tell me about the processes in the team — how did you work according to Scrum?

Senior
165

Can you give the latest example of a task you enjoyed?

Senior
165
/11