Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

100 Most famous interview Questions and Answers Expand / Collapse
Author
Message
Posted Wednesday, October 31, 2012 11:24 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 24, 2014 1:22 PM
Points: 259, Visits: 1,087
[b]Jeff Moden (10/29/2012)For all those who would use such a thing... Caveat Emptor!

And while you're studying such canned answers, be advised that a lot of us don't ask canned questions on interviews especially for senior positions.


As correct as your response is, and I agree with it completely, the reality for many DBA position interviews is that they often begin with interviewers' pet questions about obscure facts and/or T-SQL coding examples. My experiences are that challenging interviewers as to why they think that some bit of trivia is important and/or useful usually backfires. They don't appreciate being asked to explain themselves.

So, for dealing with reality, no matter how inappropriate it is, it doesn't hurt to try to be prepared for the inane questions that some interviewers think are important.
Post #1379459
Posted Wednesday, October 31, 2012 12:43 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
Lee Crain (10/31/2012)
[b]Jeff Moden (10/29/2012)For all those who would use such a thing... Caveat Emptor!

And while you're studying such canned answers, be advised that a lot of us don't ask canned questions on interviews especially for senior positions.


As correct as your response is, and I agree with it completely, the reality for many DBA position interviews is that they often begin with interviewers' pet questions about obscure facts and/or T-SQL coding examples. My experiences are that challenging interviewers as to why they think that some bit of trivia is important and/or useful usually backfires. They don't appreciate being asked to explain themselves.

So, for dealing with reality, no matter how inappropriate it is, it doesn't hurt to try to be prepared for the inane questions that some interviewers think are important.


I must be dealing with a different subset of interviewers than you are. I've never yet had that kind of question.

Number of columns per table? That's trivia. Given the very meaning of "trivia", it's impossible for anyone to anticipate every piece of trivia that someone else might ask. One of the key laws of human interaction is always, always, always, "Everyone you meet knows things you don't." There's reciprocity for that, of course, in that you know things nobody else does.

Theoretically, if I am ever asked that kind of question, I'd be inclined to answer something like, "I know there is an upper limit, but a properly normalized database should never approach that limit. If it ever does matter, I can look it up, but it's not something that's ever mattered to me yet."

(Note, last time I was job hunting, I got 6 offers in 6 interviews, in 1 week. All at or above my asking salary, which was already higher than average for the market I'm in. Just to point out that my way of handling interview questions seems to work for me.)

When I do the other side of it, if I ever asked such a "how many" type question, it would be a stress test more than a valid question. I'd probably ask something like, "How many flux capacitors does it take to implement a non-boolean Where clause in a semi-deterministic function?"

Edit: Forgot to include the answer to the flux capacitors question. It's obviously 42, as everyone knows.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1379490
Posted Wednesday, October 31, 2012 1:03 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 36,995, Visits: 31,516
I agree... I've never asked such trivial questions as to how many columns a table can hold for the very reasons that Gus stated. My point was meant to explain simply that wrote memorization of sometimes incorrect "trivial facts" are not sufficient to pass an interview unless the interviewer is also clueless.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1379495
Posted Wednesday, October 31, 2012 1:59 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
Jeff Moden (10/31/2012)
I agree... I've never asked such trivial questions as to how many columns a table can hold for the very reasons that Gus stated. My point was meant to explain simply that wrote memorization of sometimes incorrect "trivial facts" are not sufficient to pass an interview unless the interviewer is also clueless.


On the other hand ... if anyone ever publishes "Trivial Pursuit, DBA Edition", they could come in very handy indeed!


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1379516
Posted Wednesday, October 31, 2012 2:10 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 8:15 AM
Points: 653, Visits: 1,428
Does anyone ever ask or get asked what ACID properties are? I've been asked that one a number of times by non-DBA's grasping for interview questions. Whenever I interview DBA candidates, I am less impressed with what they can regurgitate than I am with real world scenario examples. I believe they call them "behavioral example" questions.
Post #1379520
Posted Wednesday, October 31, 2012 2:12 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 11:36 AM
Points: 3,545, Visits: 7,655
GSquared (10/31/2012)
On the other hand ... if anyone ever publishes "Trivial Pursuit, DBA Edition", they could come in very handy indeed!

Would you buy it? Or would you play it?

EDIT: wrong quote.



Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1379521
Posted Wednesday, October 31, 2012 9:26 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 24, 2014 1:22 PM
Points: 259, Visits: 1,087
George M Parker (10/31/2012)
Does anyone ever ask or get asked what ACID properties are?


On just about every interview I've ever been on.
Post #1379598
Posted Wednesday, October 31, 2012 10:22 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 11:47 PM
Points: 3,135, Visits: 11,481
I like to ask a couple of easy trivial questions to get things started, and then ask one that a lot of senior DBA might stumble over. Just to shake things up.

What is the money data type used for?

What function can you use to get the current date and time?

How would you move a 2 TB database from one server to a server at a different site connected via a T1 WAN link with a maximum application downtime of 30 minutes?


Post #1379610
Posted Wednesday, October 31, 2012 11:53 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 36,995, Visits: 31,516
Michael Valentine Jones (10/31/2012)
I like to ask a couple of easy trivial questions to get things started, and then ask one that a lot of senior DBA might stumble over. Just to shake things up.

What is the money data type used for?

What function can you use to get the current date and time?

How would you move a 2 TB database from one server to a server at a different site connected via a T1 WAN link with a maximum application downtime of 30 minutes?




The developer candidates I've been interviewing can't make it past your second question (SERIOUSLY!)

The answer to your third question is "Why would you want 30 minutes of downtime when you can do it in virtually 0 seconds?"


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1379634
Posted Thursday, November 1, 2012 7:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 7:44 AM
Points: 12,910, Visits: 32,015
here's a link to a copy of the pdf that doesn't require his damn password.
boy that pissed me off for some reason.


oh, and some of his code example references the DECODE function, which is actually an Oracle function.
SQL would use a CASE statement.

sqlserver2008r2_cheatsheet_v1-01_unlocked.pdf


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1379799
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse