I like to gauge the maturity of candidates, but I make sure to never use gotcha questions. I propose them comfortable real world scenarios, and help them show the best of their thought process.
I've interviewed many people who were very good at answering this kind of theoretical questions but were short on delivery when I proposed them the test project supposed to demonstrate how readily they use these concepts in real world situations.
Quite frankly, it looks like the author has the graduate syndrome : http://read.reddy.today/read/10/the-graduate-syndrome
- What is DB indexing
- Can you think of any impact when indexing in this situation
- What are you general thoughts about indexing, can you think of an example when you used it and how it helped.
Will indeed give you insight into how he approaches problems and his maturity. But the difference with this and : tell me how indexing works behind the scenes, is that you focus on what really matters.
With that there is no right or wrong answers, there's just insightful answers.
I do not disagree on the fact that fundamental knowledge is important, but I disagree on the way you assess it. I disagree on the notion that there is an equivalence between fundamental knowledge and formal knowledge. One can be comfortable adding things up without knowing that it is called an addition.
If he does : great, if he doesn't it doesn't matter as long as he has the insight.
More generally the majority of our knowledge is not formal.
Yeah I asked exactly same question, And instead of answering what it i, candidtate told me why they used it.
> - Can you think of any impact when indexing in this situation
That's Why I want to know if candidate understand what really index does, One cant tell a realistic answer of this question until S(h)e knows how index works.
> - What are you general thoughts about indexing, can you think of an example when you used it and how it helped.
Even if one used it in some situation in pastm and it helped, I would consider it not enough as it could be possible S(h)e used it by reading some blog/tutorial etc without understanding it fully, it's like ok switch it off and on, did it work? well forget about it then.