Interview questions on SQL Server 2005.

  • Can anyone send me some interview questions pls.

    I recently got into DBA and I wanna stick to it as am very much interested in this.

    The problem is that my manager is forcing me to work on other technologies

    as there is no much work on database in our company.

    I don't want to switch to any other technology now but I have never given any interview for DBA post.

    Kindly help me with questions and also lemme know if there's vacance for SQL Server 2005 DBA.

    Thanks in advance.

  • swmsan (2/17/2009)


    Can anyone send me some interview questions pls.

    I recently got into DBA and I wanna stick to it as am very much interested in this.

    The problem is that my manager is forcing me to work on other technologies

    as there is no much work on database in our company.

    I don't want to switch to any other technology now but I have never given any interview for DBA post.

    Kindly help me with questions and also lemme know if there's vacance for SQL Server 2005 DBA.

    Thanks in advance.

    Hi!

    To be able to tell you if there are any vacancies we need to know in which country and region you are looking. I know there are some open vacancies in Stockholm (SWEDEN), most of them are looking for senior DBA:s, but I know at least one company looking for a junior DBA ( G4S )

    /Håkan Winther

    Senior Development DBA

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • I am in India, but ready to relocate to anywhere in the world.

    I would be more than happy if I can get some job in Australia or Japan as I have few friends over there.

    Otherwise also not an issue and I can relocate even to Sweden. Kindly let me know the job details pls.

    Thank you.

  • swmsan (2/17/2009)


    Can anyone send me some interview questions pls.

    Different companies will ask different questions. Memorising sample questions is unlikely to help.

    Advice:

    Relax

    Don't exaggerate your abilities.

    If you don't know an answer, admit it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Hi,

    I've only the Questions without answers, If you wanted I can send them to you :):D

    -------------------------------------------------------------
    "It takes 15 minutes to learn the game and a lifetime to master"
    "Share your knowledge. It's a way to achieve immortality."

  • Please Send it ....I will find the answers..

    Thanks.

  • Different companies will ask different questions. Memorising sample questions is unlikely to help.

    Advice:

    Relax

    Don't exaggerate your abilities.

    If you don't know an answer, admit it.

    You are right..but there might be some common basic questions...Recently one person asked me below 2 questions.

    How can I verify that backups are occurring on a daily basis?

    How do you know if your database backups are restorable?

    I do backup restore 10 times a day...still I was not able to answer such questions...

    Thanks.

  • swmsan (2/18/2009)


    I do backup restore 10 times a day...still I was not able to answer such questions...

    Errr, those are pretty trivial questions. If you don't know the answers, how well do you really know backups? Concentrate on improving your knowledge of the product, not on specific questions.

    If I'm interviewing a person, I want to know what they know and what they don't, not what interview questions they're memorised.

    http://sqlbatman.com/2009/02/interviewing-tips/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Errr, those are pretty trivial questions. If you don't know the answers, how well do you really know backups? Concentrate on improving your knowledge of the product, not on specific questions.

    http://sqlbatman.com/2009/02/interviewing-tips/

    Many thanks for the advice. I am working more to improve my knowledge on SQL Server. Basicaly am not a DBA, I was completely into development using VB, ASP, Cold Fusion & Dev 2000. Just got into DBA activitie n decided to stick to it.

    Once again Thanks alot.

  • GilaMonster (2/19/2009)


    ...If I'm interviewing a person, I want to know what they know and what they don't, not what interview questions they're memorised...

    [/url]

    Although that would be quite a novel experience - kinnda like a game show.

    Edit: The royalties are mine...

    Max

  • swmsan (2/18/2009)


    Please Send it ....I will find the answers..

    Thanks.

    Ok, I've just send them to you, hope they are good 😉 😀

    -------------------------------------------------------------
    "It takes 15 minutes to learn the game and a lifetime to master"
    "Share your knowledge. It's a way to achieve immortality."

  • swmsan (2/19/2009)


    Many thanks for the advice. I am working more to improve my knowledge on SQL Server.

    Then spend time here. On this forum you'll see hundreds of problems and questions, most of which get answered. See if you can figure out the answers before reading what other people have said. Make sure you understand the answers and, if you don't, post and ask.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (2/19/2009)


    swmsan (2/18/2009)


    I do backup restore 10 times a day...still I was not able to answer such questions...

    Errr, those are pretty trivial questions. If you don't know the answers, how well do you really know backups? Concentrate on improving your knowledge of the product, not on specific questions.

    If I'm interviewing a person, I want to know what they know and what they don't, not what interview questions they're memorised.

    http://sqlbatman.com/2009/02/interviewing-tips/

    I agree! I really dont want to hire someone thats not suitable for the job. It can be a complete disaster to hire someone that does not have the right competence. I and many other DBA:s with me agree that the DBA role is a key position. We do not want someone to give us bad reputation.

    Please be honest to a former employeer, if he wants a junior DBA, he/she will hire you anyway and give you an opertunity to learn from someone more senior.

    /Håkan Winther

    Senior development DBA

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • You might get hired by someone that also needs a little development help and is willing to help you learn SQL Server on the job.

    Tell them what you know, be honest about what you don't. And most importantly, if you don't know something, let them know you can find the answer.

  • swmsan (2/18/2009)


    Please Send it ....I will find the answers..

    Thanks.

    [font="Verdana"]Frankly, if I were interviewing you, I would keep asking questions until I found something you didn't know about. Then I would look for your reaction. If you were honest, told me you didn't know, but told me you could find out (and some idea of how), that's what I would be looking for.

    A good DBA is (amongst other things) someone who knows how to find out stuff and apply it. It's an attitude. A poor DBA is someone who when they run into something they don't know... just stops.

    So from my point of view, in an interview, the sort of answer you already gave would be exactly what I look for. 😀

    Treat an interview as a conversation, not a gameshow. You're not there to recite answers to questions. You are there to:

  • Give an indication of your level of experience
  • Decide whether you are the type of person who will fit into the role and with the other people
  • Decide whether you have the right skills
  • Decide whether you have the right attitude
  • BTW, this is one reason why I'm not fond of industry qualifications. All they really do is show that someone can study to pass an exam (vaguely useful). They don't show how that person deals with the unknown or how they react under pressure.

    [/font]

Viewing 15 posts - 1 through 15 (of 40 total)

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