February 26, 2009 at 2:30 am
when an given an interview,one interviewer asked question like this:---
Q:-[/b]When u open the Enterprise manager u find out the database...and u clik on that databases u see what are the databases available in the databases.
can anyone tell me which executable file running behind this?
February 26, 2009 at 2:40 am
This is very silly question. Interviewer must be crazy.
But you can say here. for mamagement studio it is mmc.exe for 2000, SqlWb.exe for 2005 and Ssms.exe in 2008.
Regards,
Nitin
March 6, 2009 at 6:21 am
ashok.nayak1 (2/26/2009)
when an given an interview,one interviewer asked question like this:---Q:-[/b]When u open the Enterprise manager u find out the database...and u clik on that databases u see what are the databases available in the databases.
can anyone tell me which executable file running behind this?
OMG!!! :w00t:do you guys really think that a DBA should know answer to this question? What if you don't know the answer, do the interviewer fail you?
March 6, 2009 at 8:52 am
If interviewer is System Admin, then he might think to reject the candidate. 😉
Regards,
Nitin
March 6, 2009 at 9:06 am
But, is it acceptable though to ask such a question at a DBA interview? or may be OP attended a system admin interview:P, anyways I would be blown out of my head if i was asked that question:w00t:
March 8, 2009 at 11:33 am
also depends on if they mean client or server side. Server process is sqlservr.exe
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 11:40 am
Perry Whittle (3/8/2009)
also depends on if they mean client or server side. Server process is sqlservr.exe
Server or client, how important is it really for a candidate to know that? Seriously, how often does knowing the name of the executable come up?
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
March 8, 2009 at 1:17 pm
If you don't know the name of the executable, how can you do resource balancing on a machine with multiple instances - e.g. using WSRM?
I think it's a reasonable question.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
March 8, 2009 at 1:32 pm
GilaMonster (3/8/2009)
Perry Whittle (3/8/2009)
also depends on if they mean client or server side. Server process is sqlservr.exeServer or client, how important is it really for a candidate to know that? Seriously, how often does knowing the name of the executable come up?
if an admin is to trace a sql server instance or check its memory usage, shouldnt they at least know what the process is called?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 1:33 pm
Paul Randal (3/8/2009)
If you don't know the name of the executable, how can you do resource balancing on a machine with multiple instances - e.g. using WSRM?
You look it up when it's needed. It's not something I'd expect someone to have memorised. Doubly so if, as it seems from the initial question, the interviewer's asking about the executable name of the client tool.
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
March 8, 2009 at 1:40 pm
i had a telephone interview last week for a job and the interviewer asked me to provide port numbers for some commonly used TCP ports (e.g. DNS, SQL, POP3,etc). If i had said "i'll go look it up when i need it" i wonder if i would have still passed the interview 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 1:56 pm
There's a cliched phrase: the more you know, the further you go.
When I used to interview people to be devs or managers on my various teams at Microsoft, one of the (many) things I'd look for was who just knew stuff off the top of their head. The smarter folks with the most interest would be the ones who'd dug around and knew funky stuff like that.
If I was asking that question though, I'd follow up by asking 'And why would that be useful to know?' to weed out those who just learned rote facts for the interview.
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
March 8, 2009 at 1:59 pm
Perry Whittle (3/8/2009)
i had a telephone interview last week for a job and the interviewer asked me to provide port numbers for some commonly used TCP ports (e.g. DNS, SQL, POP3,etc). If i had said "i'll go look it up when i need it" i wonder if i would have still passed the interview 😉
If I was ever asked that in an interview, that's exactly the answer I would give.
That kind of info is easy to lookup. There's no need to memorise long lists of port numbers. Personally, I prefer to ask questions that cannot be answered by rote memorisation.
I've encountered and heard of way too many interviews where the interviewer acts like it's a game of "Who wants to be a millionaire" where the interviewer comes up with the most obscure questions possible.
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
March 8, 2009 at 2:05 pm
One more thing - people that know stuff like IP port numbers, and can answer follow-on questions have obviously used them enough to have them in their heard, therefore you might assume they're more experienced. If I was interviewing someone and had more than one "i'd look that up" answer, I'd be inclined to put them lower on a hire list than others.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
March 8, 2009 at 3:42 pm
if a manager asks you to setup Perfmon to monitor sql server processes and uses (especially on a multi instance box) he wouldnt expect you to say " yeah i'll just go look it up". I'm not here to argue with you Gail and to a certain extent i agree (why would a dba need to know POP3 is port 110)but there are fundamentals which the individual should know. Also in todays climate more and more companies are looking for a database orientated individual who can carry off other critical infra structure duties. I mean the sql client process is really a desktops related application.
Further, If you replied to the interviewer client side is ............ and server side is sqlsrvr.exe i think it would put you further up the hiring list, as Paul said.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 1 through 15 (of 26 total)
You must be logged in to reply to this topic. Login to reply