Interview Que

Question

Interview Que

saidapur_satish

SSC Veteran

Points: 288
More actions
December 26, 2010 at 3:08 am

#242681

Hi All,
Last week i attended a interview by telephonic, he asked a question some thing like.
If your database move Testing server to online server what are changes you will do?
I am not understand this one please help for this one....
Thanks & Regards
Satish Saidapur

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

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

Jeff Moden SSC Guru Points: 1004301 More actions · Answer 1

saidapur_satish (12/26/2010)
Hi All,
Last week i attended a interview by telephonic, he asked a question some thing like.
If your database move Testing server to online server what are changes you will do?
I am not understand this one please help for this one....
Thanks & Regards
Satish Saidapur

It's definitely a question to make you think. For example, is all DRI in place? Does it temporarily need to be overridden? Is there a "backout" plan if something goes horribly wrong? Are you moving the whole server or is the Testing Server just a "staging area" for testing and the individual procs and tables will need to be promoted to the "online server". If there are new tables to replace old tables, what is the migration plan? Is there any GUI code that will be affected? Are there required changes in nightly maintenance? Etc, etc, etc.

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

saidapur_satish SSC Veteran Points: 288 More actions · Answer 2

Hi Jeff Moden,

Thanks, but i am not get properly could you explain me main things commonly what DBA will do?

Thanks & Regards

Satish Saidapur

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

saidapur_satish (12/26/2010)
Thanks, but i am not get properly could you explain me main things commonly what DBA will do?

How much experience do you have as a DBA and what position was this interview for? I get the impression you've never done code deployment before.

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

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

saidapur_satish (12/26/2010)
Hi Jeff Moden,
Thanks, but i am not get properly could you explain me main things commonly what DBA will do?
Thanks & Regards
Satish Saidapur

People write entire books about such things which is, obviously, much more than you could learn from my simple forum post. My recommendation would be to start with Google on the "Duties of DBA" especially if you're considering it as a career path. Perhaps even take a course on the subject.

You'll also find that many people (I'm actually one of those people) don't like to help with interview questions. The reason is that if we were doing the interview, we wouldn't want someone who had simply memorized a bunch of canned answers. We would actually want someone who had done the work and knew the answers.

If you change your line of questioning as to where you can learn SQL and which courses you may be able to invest a little time in, then I'm sure people will be happy to jump in.

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

saidapur_satish SSC Veteran Points: 288 More actions · Answer 5

Hi Gail,

2.5 Year experience on SQL DB & i am working on BACKUP & RESTORING, Installation, Snapshot, Mirroring, Marge replication & security.....

Thanks & Regards

Satish Saidapur

crazy4sql SSCoach Points: 19590 More actions · Answer 6

saidapur_satish (12/29/2010)
Hi Gail,
2.5 Year experience on SQL DB

first of all it doesnt matter how many yrs of exp you have as sqldba what matters is how much you learned in those years.

i am working on BACKUP & RESTORING, Installation, Snapshot, Mirroring, Marge replication & security.....

I am assuiming you invloved in support. Be involved in configuring environment on these technologies, you will learn more and I am sure you will answer your question yourself.

----------
Ashish

saidapur_satish SSC Veteran Points: 288 More actions · Answer 7

Hi Ashish,

I am involved in support & Devlopment team but i am not got proper answer..........................

Thanks & Regards

Satish Saidapur

LutzM SSC Guru Points: 107049 More actions · Answer 8

saidapur_satish (12/29/2010)
Hi Ashish,
I am involved in support & Devlopment team but i am not got proper answer..........................
Thanks & Regards
Satish Saidapur

If you're already involved in a dev team, I recommend you ask the folks responsible for deployment.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]