I just had an initial phone screen with a guy who wants the DBA gig I’ve got open. Here are the last 2 questions I asked him with his answers.
Q: Say you have a prod server with the DB on D:\ and you need to restore it to a dev server that has no D:\. But it does have an E:\… how would you restore that DB to E:\ instead of D:\?
A: FTP.
Q: Can you name 2 server-level security roles?
A: DBA and Dev.
Sorry I asked. I’ll just be over here.
LOL! Too bad I don’t live in your neck of the woods – would love to work for ya. Oh, and I could answer both those questions too!
here are my answers:
A1. Magic.
A2. Yes, but you don’t have the right security clearance, Clarence.
I hope this was a senior DBA candidate 🙂
Nice to have job security.
Wait, those answers are wrong?
As a matter of fact it was. He’s got 10+yrs.
A1: Consult #sqlhelp
A2: See A1
I’ll take a crack at it:
1. On the production server, use disk management to change D:\ to E:\, backup, restore to secondary server, then switch back.
2. Master and Model. Master controls the system. Model is just there to look pretty.
Do I get the job? No? *whine*, *whine*…
🙂
-D.
Well, technically, he was right, but his answers were incomplete.
You guys are just catering to the elites….
If you mean DBA as in Developer Beating Administrator…he I might still consider bringing him in for an in person interview
Some days I don’t feel good about myself. Pretty sure this would turn even the worst of those days around 😀
Wow. Just last night friend asked me if I was interested in a DBA gig where he works. I told him I have 0 years experience as a DBA and he would be better off looking for someone who did. But after seeing those answers, maybe that was bad advice.