Here are some SQL Server Interview Questions

  • Grant Fritchey (5/19/2015)


    SQLRNNR (5/19/2015)


    Along the lines of interview questions, let's just throw this question out there.

    If you are hiring for a senior position, you create an exam for the position, you require applicants to take the exam and then when grading it you are proven to be wrong in your understandings of key principles what do you do?

    Do what happened to me. Hire the other guy who got all the questions right including the one that was wrong but graded incorrectly over me who educated them about how the answer was wrong (nicely, btw).

    LOL - it looks like this client is probably going to do that same thing.:crazy:

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Luis Cazares (5/19/2015)


    SQLRNNR (5/19/2015)


    Along the lines of interview questions, let's just throw this question out there.

    If you are hiring for a senior position, you create an exam for the position, you require applicants to take the exam and then when grading it you are proven to be wrong in your understandings of key principles what do you do?

    Continue to mark the answers from applicants as correct for questions you just discovered were wrong (well because it is a common myth so why punish them)?

    Or do you mark the answers from applicants as incorrect?

    E.g. A common misconception is that truncate cannot be rolled back. A senior level for a client thought the same way. A candidate said a truncate could not be recovered (even worse than rolled back). But the "senior" said it was ok because nobody knows the difference.

    Simple, I don't grade the exams as right or wrong. I'll go through them with the person to complete their answers and be sure if they're just remembering some notes, making up stuff, being so nervous that can't explain themselves on paper or simply are very knowledgeable and confident (still waiting for this).

    Interesting, I wonder if I can get these guys to let me do their interviews... hmmm

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Eric M Russell (5/19/2015)


    But honestly, I could coach an average 12 year old how to fake their way through a SQL Server interview, if all it involves is knowing the right answer to a set of 100 possible boilerplate questions that anyone can google on the web. In fact, kids are probably better at that "game" than adults.

    No argument there.;-)

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR (5/19/2015)


    Eric M Russell (5/19/2015)


    But honestly, I could coach an average 12 year old how to fake their way through a SQL Server interview, if all it involves is knowing the right answer to a set of 100 possible boilerplate questions that anyone can google on the web. In fact, kids are probably better at that "game" than adults.

    No argument there.;-)

    Which leads to the next question. "Who would you rather practice your interview skills with? The faceless hordes of the interwebs or your kids?"

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Brandie Tarvin (5/19/2015)


    SQLRNNR (5/19/2015)


    Eric M Russell (5/19/2015)


    But honestly, I could coach an average 12 year old how to fake their way through a SQL Server interview, if all it involves is knowing the right answer to a set of 100 possible boilerplate questions that anyone can google on the web. In fact, kids are probably better at that "game" than adults.

    No argument there.;-)

    Which leads to the next question. "Who would you rather practice your interview skills with? The faceless hordes of the interwebs or your kids?"

    My kids :-D:-D:-D

    That can be so much more fun with more immediate feedback.;-)

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 5 posts - 106 through 109 (of 109 total)

You must be logged in to reply to this topic. Login to reply