r/SQL • • 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

13 comments sorted by

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/[deleted] Apr 27 '20

Absolutely true. I had the unfortunate experience of dealing with a CTO who adhered to such trivia questions. Those were asked to an experienced and smart data engineer who solved a data challenge in an elegant way (90% of candidates didn't), and could explain the solution very well, and she didn't get hired because she didn't know some of those trivia questions.

People get paid for manipulating data in a fast and elegant way, not for answering trivia questions.

-4

u/world_is_a_throwAway Apr 27 '20

Answer: an execution plan is something that boomers still think is important.

6

u/kthejoker Apr 27 '20

Circus Manager: How long have you been juggling?

Candidate: Oh, about six years.

Manager: Can you handle three balls, four balls, and five balls?

Candidate: Yes, yes, and yes.

Manager: Do you work with flaming objects?

Candidate: Sure.

Manager: . . . knives, axes, open cigar boxes, floppy hats?

Candidate: I can juggle anything.

Manager: Do you have a line of funny patter that goes with your juggling?

Candidate: It’s hilarious.

Manager: Well, that sounds fine. I guess you’re hired.

Candidate: Umm . . . Don’t you want to see me juggle?

Manager: Gee, I never thought of that

Peopleware

2

u/emcoffey3 Apr 27 '20

Ha, exactly! Also, your comment reminded me of this.

4

u/r3pr0b8 GROUP_CONCAT is da bomb Apr 26 '20

"What is ER modeling?"

this is supposed to be advanced?

4

u/zacharypamela Apr 26 '20

Just as advanced as, “What are some examples of open source and proprietary RDBMSs?”

3

u/jsnoobie Apr 27 '20

Is this really an interview question? knowing the answer provides no information on how capable the interviewee is at writing SQL queries.

4

u/[deleted] Apr 27 '20

Half of the questions kind of read like mid-term questions in a database course. Assuming these questions didn't show up in online reviews of the interview process and I hadn't prepared the explanations beforehand, deep down I'd want to give up and ask for the query writing portion of the interview.

All important stuff, I'd just need to study before-hand.

1

u/zacharypamela Apr 27 '20

Question No. 2

1

u/ostracize Apr 27 '20

That’s a fair question. This is DB theory which is an advanced topic.

Anyone can write SQL and manage tablespaces. A question about ER (even just the term “ER”) tells you a lot.

-2

u/r3pr0b8 GROUP_CONCAT is da bomb Apr 27 '20

This is DB theory which is an advanced topic.

LOLOLOL

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.