O'Reilly Auto Parts Software Developer interview questions

easy hackerrank question with sql join

hackerrank question similar to merge intervals on leetcode. this one was a little tricky to complete in 20 minutes but doable if not under interview stress

technical questions on java like virtual vs synchronized. name uses of static. what is a db index when do you use one or when do you not use one etc. review basic sql syntax for ddl and dml. review a pr with their "sr" developer who got angry when I pointed out a basic exception it was throwing that he had missed. Their tech stack looks old-ish, possibly 2015ish with no mention of microservices, event streaming, or even any container management or control plane of any kind so no need to review any of those.