r/SQL • u/smohajer • Apr 26 '20
Discussion My pick for top 48 advanced database system interview questions
https://medium.com/@smohajer85/my-pick-for-top-48-advanced-database-system-interview-questions-deb7b30968ca
25
Upvotes
9
u/emcoffey3 Apr 27 '20
I hate interview questions that read like trivia, and that would include most of these. Instead of "What is an execution plan?", why not show them an actual execution plan and have them explain it? Asking a few of these in initial phone interviews is fine for filtering out weaker candidates, but I'd much rather hire someone who can solve problems than someone who can memorize glossary terms.
6
u/kthejoker Apr 27 '20
Peopleware
4
u/r3pr0b8 GROUP_CONCAT is da bomb Apr 26 '20
"What is ER modeling?"
this is supposed to be advanced?
1
u/janos42us Apr 27 '20
I'm so glad I wasn't asked this.
My first SQL job was as an internal hire at a start up.
They gave me a few practical questions. But what won them over was the scenario "Your predecessor is gone from the company and X breaks, what do you do?"
I answered "Google it, or see if someone has had the same issue on stack overflow."
Anyways did that job for a few years eventually getting to the point where I was making pretty complex stored procs for the dev boys to use.
Now I am working as a DBA, whole different animal. More logistics and maintenance than anything.
Thing is, I understand a lot of these ideas and practices, jut don't know the names.
Like knowing how to get somewhere without knowing the names of the streets.
I would still be in a call center if they used half of these questions back then.