I interviewed with a robot online and they recorded my video.
I answered the oldest programming question and their feedback was:
"Thanks so much for taking the time to submit your video. Your passion for the subject was palpable! :-)
However, some of your answers to the more technical questions weren't quite on point. For example, when reasoning about slow queries you talked a bit about the n+1 problem, a common problem to be sure, but you didn't offer solutions to the actual thing we asked about."
and my answer was:
"N+1 is a common problem in SQL. The solution for N+1 is (as I said) eager loading and lazy loading which meant Join table. Other than that over-indexing, under indexing or no clustered Index/primary key is other issues in SQL, it depends what is your definition of optimisation, is its speed, is it less query, is it execution time or is it memory usage. I don't think the question was clear nor any of your devs know this keeping in mind that the answers could be researched.
Your feedback isn’t clear, the solution can be demonstrated in code, not a verbal explanation. I’m a developer and practical person. Remember one mechanic can talk and another mechanic can fix cars. which one your company prefers?"
You are the judge.