SQL SERVER CLUSTERING INTERVIEW QUESTIONS

Question

Post reply

SQL SERVER CLUSTERING INTERVIEW QUESTIONS

gajananhatkar

Mr or Mrs. 500

Points: 541
More actions
September 8, 2011 at 10:27 pm

#244446

hi,
if any one having sql server clustering interview questions please forward the zip files and link related to that.

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

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

The following is not specifically for Interview questions but it may help.

http://qa.sqlservercentral.com/articles/Administration/commonclusterproblems/470/

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 2

Personally, if you dont know about a subject enough to answer the interview questions I'd prefer you said so in the interview.

I dont want to hire someone who has mislead me in interview pretending to know something they dont.

Plus if the interviewer knows their subject you will be found out.

GSquared SSC Guru Points: 260824 More actions · Answer 3

As an aside, asking a bunch of unknown people on the Internet to send you a zip file is probably not the wisest move. Zip files can be set up to install malware on any computer opening them.

On the original question, are you looking to ask questions or answer them? That is, are you giving an interview or are you being interviewed?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 4

GSquared (9/9/2011)
On the original question, are you looking to ask questions or answer them? That is, are you giving an interview or are you being interviewed?

Oooo I never thought of that. 🙂

suresh.karuppanasamy SSC Journeyman Points: 88 More actions · Answer 5

I will have some few of the questions ..It might have some tricky ...

-> How will you restart your sqlserver on cluster without failing over ..?

Ans : Choose option ( Take offline and Bring online option by right clicking node)

-> What will you if want to add a disk to the SQL Group cluster ..?

Ans : Need to choose Add Dependancy option after doing that in Cluster administrator tool (or) in Failover Cluster admin tool from 2008 version

-> As a DBA how will you design active/active cluster requirement . (i.e), how will you manage resource if failed over ..?

Please read article from MSDN on this to have better understanding

-> Steps for failover ..?

Ans : Please red MSDN on this with full view

-> Difference between SQLSERVER 2005 and SQLSERVER 2008 Cluster Installation ..?

Ans : In sql2005 we have the option of installing sql in remaining nodes from the primary node ., But in sql2008 we need to go seperately(Login to the bith nodes) for installing sql cluster .

Thanks,

Suresh k

rehvin SSC Rookie Points: 43 More actions · Answer 6

Hi guys, I have found this resource for interview preparation https://artoftesting.com/sql-queries-for-interview

This reply was modified 3 years, 4 months ago by rehvin.

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 7

rehvin wrote:

Hi guys, I have found this resource for interview preparation https://artoftesting.com/sql-queries-for-interview

Lordy... not another one... 🙁 Jumping straight to the final two questions in the "experienced" section...

Without loading it into SSMS, tell me why the first code snippet for QUES.39 won't run in T-SQL even though it's explicitly listed as a way to solve the problem in SQL Server. And I'm not talking about the "N"... go ahead and replace that with a 3 if it'll make you feel better.

Looking at Ques.40, tell me why such "experts" never consider either the relatively extreme resource usage or run time for answers like those posted. It also doesn't work quite right. The problem definition says to find the 3rd highest salary... not all salaries that tie for the 3rd highest, which is what the example code does. If I were going to write a question, it would be to provide the given answer and ask what's wrong with it, why it needs to be fixed even in the presence of a small number of rows, and what the code is to fix it even if all ties are to be returned.

I don't know if any of the other answers are incorrect or not. I figure "2 for 2" in the "experienced" section is proof enough as to why it might be ok to use the questions as a study guide but not the answers... if would be even better to work on the questions to prove and then explain what's right or wrong about the answers.

--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)
Intro to Tally Tables and Functions

ScottPletcher SSC Guru Points: 100262 More actions · Answer 8

Jeff Moden wrote:

rehvin wrote:
Hi guys, I have found this resource for interview preparation https://artoftesting.com/sql-queries-for-interview
Lordy... not another one... 🙁 Jumping straight to the final two questions in the "experienced" section...
Without loading it into SSMS, tell me why the first code snippet for QUES.39 won't run in T-SQL even though it's explicitly listed as a way to solve the problem in SQL Server. And I'm not talking about the "N"... go ahead and replace that with a 3 if it'll make you feel better.
Looking at Ques.40, tell me why such "experts" never consider either the relatively extreme resource usage or run time for answers like those posted. It also doesn't work quite right. The problem definition says to find the 3rd highest salary... not all salaries that tie for the 3rd highest, which is what the example code does. If I were going to write a question, it would be to provide the given answer and ask what's wrong with it, why it needs to be fixed even in the presence of a small number of rows, and what the code is to fix it even if all ties are to be returned.
I don't know if any of the other answers are incorrect or not. I figure "2 for 2" in the "experienced" section is proof enough as to why it might be ok to use the questions as a study guide but not the answers... if would be even better to work on the questions to prove and then explain what's right or wrong about the answers.

I'm with Jeff on this one. Q40, wow, I can't think of a worse (more inefficient) way to do that task. That "answer" alone would make me discount the entire article.

SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!