Common questions asked in SQL Server DBA Interview

Question

Common questions asked in SQL Server DBA Interview

Viewing 8 posts - 106 through 112 (of 112 total)

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

Brandie Tarvin SSC Guru Points: 172995 More actions · Answer 1

What is the wing span of an unladen swallow?

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.

Jeff Moden SSC Guru Points: 1003870 More actions · Answer 2

Brandie Tarvin (5/14/2012)
What is the wing span of an unladen swallow?

It depends. What is the age and current speed of the swallow?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Brandie Tarvin SSC Guru Points: 172995 More actions · Answer 3

Jeff Moden (5/14/2012)
Brandie Tarvin (5/14/2012)
What is the wing span of an unladen swallow?
It depends. What is the age and current speed of the swallow?

I don't know.

<Aaaaaaaaarrrrrrrrggggghhhhhhhhhh>

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.

Jeff Moden SSC Guru Points: 1003870 More actions · Answer 4

Brandie Tarvin (5/14/2012)
Jeff Moden (5/14/2012)
Brandie Tarvin (5/14/2012)
What is the wing span of an unladen swallow?
It depends. What is the age and current speed of the swallow?
I don't know.
<Aaaaaaaaarrrrrrrrggggghhhhhhhhhh>

Then the likely answer is "enough to sufficiently suffoncify the swallow". 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Brandie Tarvin SSC Guru Points: 172995 More actions · Answer 5

tua022012 (9/10/2012)
Thanks for your link. It's useful for our community.
Same material can be found at: Production executive interview questions[/url]
I hope it's useful for you and you like it. Please continue sharing more information at this topic.
Best rgs!

Wow. I love the sockpuppet replies to that page.

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.

WorkasDBA SSCommitted Points: 1684 More actions · Answer 6

I was recently asked to provide questions to be asked for a production DBA. There are no good or bad answers, the person must have encountered most of the scenario’s with understanding on how things work & very quick to react on a highly stressful environment. Below are the questions I provided:Hope it helps

Database Back ups:

** What are the different types of database backups and specify the scenario that you have used in your experience?

High Availability:

** What are the high availability methods ?.Specify your experience and set up required for SQL Server in a clustered environment

DR :

** Specify your DR strategy experience and details for SQL server.

** Specify the steps to take when a database is corrupted (or) server is down (or) harddrive is corrupted.

Performance Tuning :

** All of a sudden a query is running slowly and there are no changes made to application/network or server environment. Based on your experience, specify the steps to debug the issue.

Maintenance Plan:

** Specify based on your experience what maintenance plans are required for a typical database.

Replication:

** Specify your experience in Transaction replication?. Provide details on issues encountered and how to resolve it.

Data Dump:

** How do you migrate data from Prod to QA to Dev environment?

Design:

** How do you carve/select storage for each of the files below:

TempDB

Data file

Log file

backup file

** How do you determine the size of a database based on your experience?

Security:

** Have you worked with secure data?. If so, how do you protect/encrypt the data?

Different types :

** Have you worked in an OLTP and Data warehouse DB’s?. if so, how is the set up different for each type

Randheer SSC Eights! Points: 985 More actions · Answer 7

Check out below link for Interview Questions and answers for SQL Server DBA

http://www.sqlserverquest.com/p/sql-server-dba-interview-questions.html

Randheer Singh

----------------------------------
CheckOut My Blog for SQL Server Realated Topics and Interview Questions for SSIS , SSRS and TSQL.

http://www.sqlserverquest.com/p/ssrs-interview-questions.html
http://www.sqlserverquest.com/p/ssis-interview-questions.html
http://www.sqlserverquest.com/p/tsql-interview-questions.html

Jeff Moden SSC Guru Points: 1003870 More actions · Answer 8

Randheer (2/25/2014)
Check out below link for Interview Questions and answers for SQL Server DBA
http://www.sqlserverquest.com/p/sql-server-dba-interview-questions.html

The link didn't work even when I copied and pasted it. 😉 I did, however, find the questions on your site.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)