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»»»

Interview questions on SQL Server 2005. Expand / Collapse
Author
Message
Posted Tuesday, February 17, 2009 11:52 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, December 15, 2014 1:46 AM
Points: 1,593, Visits: 2,661
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.
Post #659105
Posted Wednesday, February 18, 2009 12:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 11, 2014 6:27 AM
Points: 2,624, Visits: 583
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
Post #659117
Posted Wednesday, February 18, 2009 2:06 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, December 15, 2014 1:46 AM
Points: 1,593, Visits: 2,661

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.
Post #659159
Posted Wednesday, February 18, 2009 5:56 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 40,615, Visits: 37,080
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 2008, MVP
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

Post #659281
Posted Wednesday, February 18, 2009 6:08 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, November 27, 2014 1:56 AM
Points: 998, Visits: 6,478
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."


Post #659291
Posted Wednesday, February 18, 2009 10:33 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, December 15, 2014 1:46 AM
Points: 1,593, Visits: 2,661

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





Post #660048
Posted Wednesday, February 18, 2009 10:38 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, December 15, 2014 1:46 AM
Points: 1,593, Visits: 2,661

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.



Post #660051
Posted Thursday, February 19, 2009 1:16 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 40,615, Visits: 37,080
swmsan (2/18/2009)
[quote]
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 2008, MVP
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

Post #660088
Posted Thursday, February 19, 2009 3:14 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, December 15, 2014 1:46 AM
Points: 1,593, Visits: 2,661

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.
Post #660136
Posted Thursday, February 19, 2009 4:25 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 7:07 AM
Points: 247, Visits: 356
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
Post #660170
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse