October 26, 2010 at 5:26 pm
dsgerhbfTnjmtrghbzs
October 26, 2010 at 5:52 pm
sasi.tripuraneni (10/26/2010)
hello,Can any one please post Sr level interview questions, its very urgent!
thanks
Sasi.
Question 1: Did you ever go to SSC to learn rote answers to interview questions?
Question 2: Do you understand your answers enough to show me how you figured them out?
Question 3: Did you learn the underlying theory to why we put Alpha to the Omega, or are you regurgitating something you read somewhere?
etc.
If you're asking the questions for an interview you need to do, and don't understand the answer, you're going to get smokescreened.
If you're looking for a cheat sheet to study from, you're going to look the fool if they actually know what they're doing, if this is "urgent". You won't have time to study/understand the question or answer.
Either way, this is lose-lose.
Edit: Addendum: The only time the words 'urgent' and 'interview questions' should come into contact with each other is when you have an immediate and sudden need to hire anyone that knows the difference between a SQL query and a hole in the ground. A very large, obvious, hole in the ground.
Anything other then proof of a very basic skill level requires understanding for both the questioner, and the person answering.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 26, 2010 at 10:18 pm
sasi.tripuraneni (10/26/2010)
hello,Can any one please post Sr level interview questions, its very urgent!
thanks
Sasi.
What kind of exposure(time spent) do you have with ETL?
Raunak J
October 27, 2010 at 2:10 am
Craig Farrell (10/26/2010)
sasi.tripuraneni (10/26/2010)
hello,Can any one please post Sr level interview questions, its very urgent!
thanks
Sasi.
Question 1: Did you ever go to SSC to learn rote answers to interview questions?
Question 2: Do you understand your answers enough to show me how you figured them out?
Question 3: Did you learn the underlying theory to why we put Alpha to the Omega, or are you regurgitating something you read somewhere?
Question 4: Is your CV an accurate reflection of your actual skill level?
Question 5: How will you respond when the interviewer asks a question that you don't have the slightest clue about?
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
October 29, 2010 at 11:56 am
GilaMonster (10/27/2010)
Question 5: How will you respond when the interviewer asks a question that you don't have the slightest clue about?
Answer: Can you hang on for a second sir? I need to go check something on SSC.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 29, 2010 at 12:26 pm
You come to work in the morning to find that all the disks in the SAN cabinet were destroyed by a direct lightning hit and none of the databases are online. What do you do first?
October 29, 2010 at 12:39 pm
Well, if you can go in and answer how "P equals NP" in complexity issues, then you can expect to pass a senior level interview.
- 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
October 29, 2010 at 12:52 pm
Michael Valentine Jones (10/29/2010)
You come to work in the morning to find that all the disks in the SAN cabinet were destroyed by a direct lightning hit and none of the databases are online. What do you do first?
Panic, prepare resume, call headhunter. THEN (maybe, since I've got nothing better to do), search the office for the backup tapes and/or call the offsite guy and tell him we need tapes while my sysadmin orders a new san and drive system.
Well, if you can go in and answer how "P equals NP" in complexity issues, then you can expect to pass a senior level interview.
I'm one for 2, I can haz job plz?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 29, 2010 at 2:04 pm
Michael Valentine Jones (10/29/2010)
You come to work in the morning to find that all the disks in the SAN cabinet were destroyed by a direct lightning hit and none of the databases are online. What do you do first?
Turn around and go back home.
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
October 29, 2010 at 2:16 pm
I think the reflection here is that if you are qualified for a senior level position, you should have some knowledge of what might be asked, or what the job will entail. The "senior" in the title should mean that you have a large amount of knowledge about how to work with SQL Server, and some deep knowledge in a few areas. Perhaps that's T-SQL or scripting, but you ought to know how SSIS works and have had years of experience.
If you don't have that experience, you might not be qualified.
I'd expect that difficult questions would include things like:
- patterns for better development
- configuration parameters and different ways to set them
- advanced logging to multiple locations or even forwarding to a central location
- building packages from code
- expression language
October 29, 2010 at 2:41 pm
sasi.tripuraneni (10/26/2010)
Can any one please post Sr level interview questions, its very urgent!
Don't put in your resume anything that can be used against you or better rephrasing it: don't lie to the extend that your CV is your death warrant.
After asking three or four questions I use to move to what you say you know so, if your resume says you are an "expert in replication" better for you to know everything about it. Note that if your resume reads "exposure to replication" rather than "expert..." I'll understand if there are things you don't know or you are not totally sure about the matter.
_____________________________________
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.October 29, 2010 at 2:47 pm
I've seen someone score 4/10 in an interview for a DBA position. All the questions were either based on something in his resume, or based on the answer he had just given. He did not impress anyone.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 29, 2010 at 2:51 pm
Alvin Ramard (10/29/2010)
I've seen someone score 4/10 in an interview for a DBA position. All the questions were either based on something in his resume, or based on the answer he had just given. He did not impress anyone.
Details? Any particularly memorable 'answers'?
I've seen someone (who claimed to be a senior DBA) score 0/75 on a DBA technical test where the first question read:
Write a query that returns the FirstName and Surname columns from a table called Person
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
October 29, 2010 at 2:57 pm
GilaMonster (10/29/2010)
I've seen someone (who claimed to be a senior DBA) score 0/75 on a DBA technical test where the first question read:Write a query that returns the FirstName and Surname columns from a table called Person
<-- More and more this avatar gets appropriate...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 29, 2010 at 3:37 pm
GilaMonster (10/29/2010)
Alvin Ramard (10/29/2010)
I've seen someone score 4/10 in an interview for a DBA position. All the questions were either based on something in his resume, or based on the answer he had just given. He did not impress anyone.Details? Any particularly memorable 'answers'?
I've seen someone (who claimed to be a senior DBA) score 0/75 on a DBA technical test where the first question read:
Write a query that returns the FirstName and Surname columns from a table called Person
Q: What's the diiference between a dimension table and a fact table?
A: Dimension tables are static and fact table dynamic (or vice versa, I don't remember)
Q: Give an example of how you might do the different backups in order to be able to do a point in time recovery.
A: Example: Weekly full, daily transaction logs, and hourly differentials.
Interviewer: I think you have the last 2 mixed up.
Interviewee: No, no, that's the right way to do it.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply