Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL DBA high ended question (5+ years’ experience)


SQL DBA high ended question (5+ years’ experience)

Author
Message
rajeshn29.dba
rajeshn29.dba
Old Hand
Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)

Group: General Forum Members
Points: 343 Visits: 310
Hi Friends,
I would like to know SQL DBA high ended question (5+ years’ experience) what kind of questions they will ASK …………………. Just for curiosity
Thanks a lot :
Rajesh
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47281 Visits: 44392
What do you mean? What kind of questions they'll ask in what context?


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


Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16461 Visits: 13207
GilaMonster (8/5/2014)
What do you mean? What kind of questions they'll ask in what context?


I guess in a job interview.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47281 Visits: 44392
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
What do you mean? What kind of questions they'll ask in what context?


I guess in a job interview.


In that case, for 5+ years experience:

Name 3 backup types in SQL Server
List the three recovery models and the differences between them.
Name two types of indexes and the differences between them.

On the off chance that they get any of those right, then we could get into a proper discussion.


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


Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16461 Visits: 13207
GilaMonster (8/5/2014)
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
What do you mean? What kind of questions they'll ask in what context?


I guess in a job interview.


In that case, for 5+ years experience:

Name 3 backup types in SQL Server
List the three recovery models and the differences between them.
Name two types of indexes and the differences between them.

On the off chance that they get any of those right, then we could get into a proper discussion.


Good grief. Is this for 5+ years experience? I'm not a DBA but I know the answer to all of them (at least on a high-level).
I'm probably spoiled for hanging out too much on this site. :-D Cool



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17605 Visits: 32267
I asked the same questions I asked someone with 2-3 years of experience. I just expected better answers. Also, when we get to the open-ended questions, I expect answers with stories as well as questions to test assumptions, etc.

Here's a sample:
You get a phone call. The person on the phone says the database is slow. What do you do?

Your responses to this tell me what you know, how well you know it and your experience level. And, there is absolutely no way to look up the answer ahead of time. You know this stuff, or you don't.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47281 Visits: 44392
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
What do you mean? What kind of questions they'll ask in what context?


I guess in a job interview.


In that case, for 5+ years experience:

Name 3 backup types in SQL Server
List the three recovery models and the differences between them.
Name two types of indexes and the differences between them.

On the off chance that they get any of those right, then we could get into a proper discussion.


Good grief. Is this for 5+ years experience? I'm not a DBA but I know the answer to all of them (at least on a high-level).
I'm probably spoiled for hanging out too much on this site. :-D Cool


I'd expect the majority of DBAs at the mentioned level to be able to give me two backup types and two recovery models and maybe get the index question half right, maybe.


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


Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17605 Visits: 32267
GilaMonster (8/5/2014)
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
What do you mean? What kind of questions they'll ask in what context?


I guess in a job interview.


In that case, for 5+ years experience:

Name 3 backup types in SQL Server
List the three recovery models and the differences between them.
Name two types of indexes and the differences between them.

On the off chance that they get any of those right, then we could get into a proper discussion.


Good grief. Is this for 5+ years experience? I'm not a DBA but I know the answer to all of them (at least on a high-level).
I'm probably spoiled for hanging out too much on this site. :-D Cool


I'd expect the majority of DBAs at the mentioned level to be able to give me two backup types and two recovery models and maybe get the index question half right, maybe.


Yeah, everyone gets the intro level questions. "What's the difference between a deadlock, spelled d e a d l o c k, and a block, spelled b l o c k?" God I love that question. Most people carefully describe a block and then carefully describe a block. Recovery models, yes. "What's the difference between a clustered and a non-clustered index?" I've actually listed out the basic questions in a blog post. But, that's just the "get me in the door" questions. The real interview starts with my previous question.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16461 Visits: 13207
Grant Fritchey (8/5/2014)

You get a phone call. The person on the phone says the database is slow. What do you do?


Migrate from Oracle to SQL Server? Do I get the job now?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16461 Visits: 13207
Grant Fritchey (8/5/2014)

"What's the difference between a deadlock, spelled d e a d l o c k, and a block, spelled b l o c k?" God I love that question. Most people carefully describe a block and then carefully describe a block.


I'll take a stab at this (mind that I am a lowly BI developer:-)).

Blocking is when one process has locked a resource and another cannot use that resource until the first process finishes. Usually resolves itself once the first process gives up the lock.

Deadlock is when two processes have acquired locks on two different object and before they can move on they need access to each others resources. They lock each other out and there is no resolution but to kill one of the processes.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
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