SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Crazy Interviews


Crazy Interviews

Author
Message
laurie-789651
laurie-789651
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1400 Visits: 1272
Reading the topic 'Stupid Interviewer Tricks' reminded me of an interview where I couldn't tell if I was crazy or the interviewer:

I had an interview recently for an SQL Consultant contract.

The interview lasted about 20 mins, & the only SQL question was:

'Do you know about inner & outer joins?' - to which I replied 'Yes'.

I thought it can't be that easy to get a job, but it was...

I got the job!

Mind you, the rate wasn't very good.
derek.colley
derek.colley
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1916 Visits: 603
Call me arrogant but if an interviewer asked me questions which were designed to trick me, or were utterly stupid in themselves, or that were designed to be unanswerable, I probably wouldn't hang around.

There's enough work out there in the UK at the moment not to have to worry too much about getting another gig. This puts us (UK people anyway) in rather a fortunate position of being able to be picky.

I shall, of course, eat my words (and my hat) when the *next* recession turns up and we're all clinging onto our jobs like the handrail on the deck of the sinking Titanic.

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!Crazy

Want to get the best help? Click here http://www.sqlservercentral.com/articles/Best+Practices/61537/ (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

Lowell
Lowell
SSC Guru
SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)

Group: General Forum Members
Points: 68962 Visits: 40915
I had a similar interview like laurie had years ago; they were interested in whether I knew vb6, ADO and whether i knew javascript; the questions had a couple of techy questions, but the end of the interview was "can you start tomorrow".

Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Daniel Bowlin
Daniel Bowlin
SSCertifiable
SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)

Group: General Forum Members
Points: 7730 Visits: 2629
Then there is the other end of the spectrum. I once had an interview that was 8 x 30 minute sessions with a total of 13 people where they asked me everything technical, behavioral, and work style that a person could think of. I was exhausted after that.
Lowell
Lowell
SSC Guru
SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)

Group: General Forum Members
Points: 68962 Visits: 40915
Daniel Bowlin (8/7/2012)
Then there is the other end of the spectrum. I once had an interview that was 8 x 30 minute sessions with a total of 13 people where they asked me everything technical, behavioral, and work style that a person could think of. I was exhausted after that.


ouch i bet! i'd bet that even though you hit a hundred questions spot on, one or two nag at you after the interview where you ask yourself if you answered that as right as you could have.

Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Scott D. Jacobson
Scott D. Jacobson
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1272 Visits: 1020
From talking to various HR people over the years, nay even actual IT interviewers (people in IT who actually conduct interviews and/or make hiring decision) I've heard something that may or may not be true. They're not always looking for a "right" answer. Sometimes they just want to see how you reason it out, what your thought process is and if you can present some viable solutions.

Very rarely am I in a position where someone says "pick one". It's usually "come up with some options and lets discuss the pros and cons".
GSquared
GSquared
SSC Guru
SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)

Group: General Forum Members
Points: 55667 Visits: 9730
Weirdest interview I ever had was 4 hours long. They flew me out to their city, put me up in the local Hilton, rented a car for me for the day, and took me out to lunch as part of it, but then, during the interview, it went like this:

Manager draws some boxes and lines on a whiteboard, tells me it's a diagram of the company firewall and DMZ, and asks me what's wrong with it. I tell him I don't know, I'm a DBA, and don't normally configure firewalls and DMZs. There have always (in my prior jobs) been other people who handled that. He spends the next 15 minutes asking me things like, "so you've never worked for a company with a data-driven web-presence?", and grilling me on firewalls, DMZs, load ballancer and other external security measures, despite my answer to pretty much every question being "I don't know. I'm not familiar with this particular subject."

A while later, after some softball questions about things I could actually answer, their Oracle DBA (they use both products) gets up, draws a diagram on the whiteboard, with backup plans and some basic ETL flows. It was pretty clear that it was missing log backups on key databases, and I expected the question to be something like "what's missing here". Instead it was, "So, we don't do log backups on our mission-critical data. Under what circumstances would that be okay?"

I replied with some options about recovering data from ETL sources, possible use of replication or mirroring instead of PIT-restores, and a few essoteric possibilities that were "out there" a bit, but possible. It turned out the answer they were looking for was "It's okay to lose mission-critical data if you don't have enough disk space for the log backups". That's not really how they worded it, but that's what it boiled down to.

I hope, to this day, they were just trying to get a shock reaction out of me. I think I did stare at him for a few seconds with my eyes a bit wide. I don't think my jaw actually physically hit the floor, but it may have.

(As a note, data is either mission-critical, meaning losing it would critically harm the business, or it's non-mission-critical, and losing it is business-acceptable. Can't be both ways.)

It gets better.

At the end of the interview, as always, I was asked if I had any final questions. Every interview ends that way, right? So I did my usual, and asked, "Am I leaving you with any questions or concerns about my ability to do the job we're talking about here?" The answer was, "Well, you seem pretty arrogant. Have you ever made any friends?"

It gets better.

They made me an offer about 10 minutes later, while I was driving back to the airport to fly back home. A very high-pay offer, and generous moving/relocation expenses.

(I turned them down. Between the weird questions, and some distinctly odd behavior while we were at lunch, they could have offered twice what they did and I still would have turned it down. But definitely an "interesting" interview.)

- 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
Mark Eckeard
Mark Eckeard
SSChasing Mays
SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)

Group: General Forum Members
Points: 621 Visits: 505
GSquared (8/7/2012)
Weirdest interview I ever had was 4 hours long. They flew me out to their city, put me up in the local Hilton, rented a car for me for the day, and took me out to lunch as part of it, but then, during the interview, it went like this:

Manager draws some boxes and lines on a whiteboard, tells me it's a diagram of the company firewall and DMZ, and asks me what's wrong with it. I tell him I don't know, I'm a DBA, and don't normally configure firewalls and DMZs. There have always (in my prior jobs) been other people who handled that. He spends the next 15 minutes asking me things like, "so you've never worked for a company with a data-driven web-presence?", and grilling me on firewalls, DMZs, load ballancer and other external security measures, despite my answer to pretty much every question being "I don't know. I'm not familiar with this particular subject."

A while later, after some softball questions about things I could actually answer, their Oracle DBA (they use both products) gets up, draws a diagram on the whiteboard, with backup plans and some basic ETL flows. It was pretty clear that it was missing log backups on key databases, and I expected the question to be something like "what's missing here". Instead it was, "So, we don't do log backups on our mission-critical data. Under what circumstances would that be okay?"

I replied with some options about recovering data from ETL sources, possible use of replication or mirroring instead of PIT-restores, and a few essoteric possibilities that were "out there" a bit, but possible. It turned out the answer they were looking for was "It's okay to lose mission-critical data if you don't have enough disk space for the log backups". That's not really how they worded it, but that's what it boiled down to.

I hope, to this day, they were just trying to get a shock reaction out of me. I think I did stare at him for a few seconds with my eyes a bit wide. I don't think my jaw actually physically hit the floor, but it may have.

(As a note, data is either mission-critical, meaning losing it would critically harm the business, or it's non-mission-critical, and losing it is business-acceptable. Can't be both ways.)

It gets better.

At the end of the interview, as always, I was asked if I had any final questions. Every interview ends that way, right? So I did my usual, and asked, "Am I leaving you with any questions or concerns about my ability to do the job we're talking about here?" The answer was, "Well, you seem pretty arrogant. Have you ever made any friends?"

It gets better.

They made me an offer about 10 minutes later, while I was driving back to the airport to fly back home. A very high-pay offer, and generous moving/relocation expenses.

(I turned them down. Between the weird questions, and some distinctly odd behavior while we were at lunch, they could have offered twice what they did and I still would have turned it down. But definitely an "interesting" interview.)


I just don't get the "shock" interview mentality. My boss did this to one of my co-workers. He brought him in for an interview and about half way through spun around in his chair (he was sideways to the guy) and started bouncing a ball of the wall and catching it. He did this for about 10 minutes.

We hired the guy and he told me about the interview (I wasn't present) and I asked him what he thought about it. He told me he knew of hiring managers that tried to "get in your head" and it was a test. My response? I wouldn't have taken the job. While I have no problem people trying to figure me out to see if I'd be a good fit, I detest childish antics like that. Sounds like the same thing may have happened on your interview.

Mark



SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64597 Visits: 18570
Mark Eckeard (8/7/2012)
GSquared (8/7/2012)
Weirdest interview I ever had was 4 hours long. They flew me out to their city, put me up in the local Hilton, rented a car for me for the day, and took me out to lunch as part of it, but then, during the interview, it went like this:

Manager draws some boxes and lines on a whiteboard, tells me it's a diagram of the company firewall and DMZ, and asks me what's wrong with it. I tell him I don't know, I'm a DBA, and don't normally configure firewalls and DMZs. There have always (in my prior jobs) been other people who handled that. He spends the next 15 minutes asking me things like, "so you've never worked for a company with a data-driven web-presence?", and grilling me on firewalls, DMZs, load ballancer and other external security measures, despite my answer to pretty much every question being "I don't know. I'm not familiar with this particular subject."

A while later, after some softball questions about things I could actually answer, their Oracle DBA (they use both products) gets up, draws a diagram on the whiteboard, with backup plans and some basic ETL flows. It was pretty clear that it was missing log backups on key databases, and I expected the question to be something like "what's missing here". Instead it was, "So, we don't do log backups on our mission-critical data. Under what circumstances would that be okay?"

I replied with some options about recovering data from ETL sources, possible use of replication or mirroring instead of PIT-restores, and a few essoteric possibilities that were "out there" a bit, but possible. It turned out the answer they were looking for was "It's okay to lose mission-critical data if you don't have enough disk space for the log backups". That's not really how they worded it, but that's what it boiled down to.

I hope, to this day, they were just trying to get a shock reaction out of me. I think I did stare at him for a few seconds with my eyes a bit wide. I don't think my jaw actually physically hit the floor, but it may have.

(As a note, data is either mission-critical, meaning losing it would critically harm the business, or it's non-mission-critical, and losing it is business-acceptable. Can't be both ways.)

It gets better.

At the end of the interview, as always, I was asked if I had any final questions. Every interview ends that way, right? So I did my usual, and asked, "Am I leaving you with any questions or concerns about my ability to do the job we're talking about here?" The answer was, "Well, you seem pretty arrogant. Have you ever made any friends?"

It gets better.

They made me an offer about 10 minutes later, while I was driving back to the airport to fly back home. A very high-pay offer, and generous moving/relocation expenses.

(I turned them down. Between the weird questions, and some distinctly odd behavior while we were at lunch, they could have offered twice what they did and I still would have turned it down. But definitely an "interesting" interview.)


I just don't get the "shock" interview mentality. My boss did this to one of my co-workers. He brought him in for an interview and about half way through spun around in his chair (he was sideways to the guy) and started bouncing a ball of the wall and catching it. He did this for about 10 minutes.

We hired the guy and he told me about the interview (I wasn't present) and I asked him what he thought about it. He told me he knew of hiring managers that tried to "get in your head" and it was a test. My response? I wouldn't have taken the job. While I have no problem people trying to figure me out to see if I'd be a good fit, I detest childish antics like that. Sounds like the same thing may have happened on your interview.

Mark


Umm...That would be a big turn off IMO.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

FunkyDexter
FunkyDexter
Right there with Babe
Right there with Babe (728 reputation)Right there with Babe (728 reputation)Right there with Babe (728 reputation)Right there with Babe (728 reputation)Right there with Babe (728 reputation)Right there with Babe (728 reputation)Right there with Babe (728 reputation)Right there with Babe (728 reputation)

Group: General Forum Members
Points: 728 Visits: 1070
Wierdest interview I ever has was only about my second job after finishing my degree. The boss turned up an hour late and the only thing he seemed interested in was whether I liked Frank Zappa. I did, so I got the job. In hindsight I wish I hadn't accepted it as it turned out to be an unmitigated disaster. Still, you live and learn.

I have an unusual interview technique I use which some here might find unreasonable but I'd defend it to the hilt. I get two sets of lego containing exactly the same pieces. I sit in one room with a pretty random shape pre-built out of one set of lego and have the interviewee sit in another room with the other set - connected by hands free telephones. The interviewee can ask any questions they like and they've got 20 minutes to build the shape I pre-built, which is waaay too short a period for them to actually complete the task (it takes alot longer than you might think). This is actually a great test because it reveals so much about the interviewee that I believe is crucial to a good programmer. Particularly around the "softer" skills I'm typically looking for. Do they panic? Do they give up? How do they communicate? Do they ask open and closed question to understand the problem? Do they make assumptions or fully clarify the goals up front? Do they take a methodical aproach? Do they think logically and try to break the problem into smaller chunks? I'm not cruel, I lay the basic premise out in front of the interviewee before hand and what my expectations are. I tell them they probably won't finish and I just want them to get as close as possible.

Technical skills are pretty easy to test for, you just ask some technical questions. And knowing your syntax off by heart isn't really what makes a good programmer, it's about having a flair for problem solving. Those soft skills can be damn hard to test for and this is the most effective way I've ever found to do it.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search