Please clarify

Question

Please clarify

elchuru

Default port

Points: 1435
More actions
March 12, 2009 at 10:49 pm

#155407

Hi guys,
Yesterday, I attended one interview for DBA.I got following questions.But i didn't answers these questions.Please help me in this regard.
1)if log file fills 100% then how do you know?
2)what is lsn?
3)what are compatibility levels?
4)what are free reuirements to configure log shipping?
5)If log shipping fails then how do you re-initialise it?
6)Can we transfer logins and jobs from one server to another? if yes how?
Thanks
Vijay

Viewing 8 posts - 1 through 7 (of 7 total)

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

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

This is a curious list of questions. What makes you ask these particular questions?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

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

prvreddy (3/12/2009)
Hi guys,
Yesterday, I attended one interview for DBA.I got following questions.But i didn't answers these questions.Please help me in this regard.
1)if log file fills 100% then how do you know?
2)what is lsn?
3)what are compatibility levels?
4)what are free reuirements to configure log shipping?
5)If log shipping fails then how do you re-initialise it?
6)Can we transfer logins and jobs from one server to another? if yes how?
Thanks
Vijay

Gosh... do you know how to use Books Online? These are simple interview questions that you should know if you deserve the position. You really should spend some time looking them up on your own.

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

prvreddy (3/12/2009)
Yesterday, I attended one interview for DBA.I got following questions.But i didn't answers these questions.

I assume a junior DBA position.

1)if log file fills 100% then how do you know?

http://www.google.com/search?hl=en&q=transaction+log+full+site%3Amsdn.microsoft.com

2)what is lsn?

http://www.google.com/search?hl=en&q=lsn+site%3Amsdn.microsoft.com

3)what are compatibility levels?

http://www.google.com/search?hl=en&q=compatibility+levels+site%3Amsdn.microsoft.com

4)what are free reuirements to configure log shipping?

http://www.google.com/search?hl=en&q=requirements+log+shipping+site%3Amsdn.microsoft.com

5)If log shipping fails then how do you re-initialise it?

http://www.google.com/search?hl=en&q=%2Breinitialize+log+shipping+site%3Amsdn.microsoft.com

6)Can we transfer logins and jobs from one server to another? if yes how?

http://www.google.com/search?hl=en&q=transfer+logins+site%3Amsdn.microsoft.com

Seriously, all of those questions can be answered straight out of Books Online. If you're after a DBA job, Books Online is your number 1 resource and one you should be familiar with.

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

Ronald H SSCarpal Tunnel Points: 4053 More actions · Answer 4

Did you get the position?

Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2

Henry Treftz SSCarpal Tunnel Points: 4207 More actions · Answer 5

But if it is a phone screen don't answer straight out of the BOL because people can tell 🙂 Also don't bring cheat-sheets into the interview

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 6

We are more than happy to help, but we want you to do a little work first. Go research those questions, search in Books Online. If you don't understand something specifically, like how compatibility modes operate, ask that. We can help explain it better.

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 7

Steve Jones - Editor (3/13/2009)
We are more than happy to help, but we want you to do a little work first. Go research those questions, search in Books Online. If you don't understand something specifically, like how compatibility modes operate, ask that. We can help explain it better.

I'm 100% in agreement, we can pass you the ball but you have to show yourself open and willing to catch and carry it for at least a few yards. You may get hit in the process but that's the beauty of it, isn't it?

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.