November 3, 2010 at 9:50 pm
can any one tell some interview questions in DBA & Developer
November 3, 2010 at 11:34 pm
This has lot of options listed.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 5, 2010 at 6:49 am
How about Pinal Dave's web site?
November 5, 2010 at 7:44 am
Scott Arendt (11/5/2010)
How about Pinal Dave's web site?
It's really interesting how many things he has wrong in that.
- 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
November 5, 2010 at 11:04 pm
Thank you,your blog very useful for me
Regards
sankar
November 6, 2010 at 12:50 pm
sankarkot2007 (11/3/2010)
can any one tell some interview questions in DBA & Developer
In my opinion, if you don't know the answers or don't know where to find the answers, you don't deserve the job.
There is nothing wrong with preparing yourself for an interview, but what about trying to get to know the technical stuff instead of memorizing q&a?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 6, 2010 at 1:57 pm
Hello Da-Zero
don't post these type of suggestions,ok.I learn beggener stage Thats why i want some questions
November 6, 2010 at 2:58 pm
sankarkot2007 (11/6/2010)
Hello Da-Zerodon't post these type of suggestions,ok.I learn beggener stage Thats why i want some questions
I - along with many others on this forum - think the same as Da-Zero. Learn the product, not a list of questions, and you'll find it much more rewarding. There's also less chance that you will be employed under false pretences. Perhaps that is a negative for you.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
November 6, 2010 at 6:40 pm
sankarkot2007 (11/6/2010)
Hello Da-Zerodon't post these type of suggestions,ok.I learn beggener stage Thats why i want some questions
Allow me to give a friendly warning. Asking for interview questions on this particular site will likely get your head handed to you. As you say, "don't post these type of" questions.
If you want some questions, all you have to do is look in the forums in this site. There are hundreds of thousands of questions and some are answered by a miriad of wizards. It all depends on how the question is asked.
But... since you're a newbie and seem to want to learn, here's a question... what are all the possible causes of performance problems in a given snippet of code?
--Jeff Moden
Change is inevitable... Change for the better is not.
November 7, 2010 at 1:15 am
sankarkot2007 (11/6/2010)
Hello Da-Zerodon't post these type of suggestions,ok.I learn beggener stage Thats why i want some questions
As Jeff mentioned above, that particular question is a trap. It implies someone looking to get a job without understanding the material. I understand your position, but don't ask for interview questions.
Ask something more like this:
"What are the first fundamentals I should concentrate on when looking to get involved in <type of position>?"
DBA:
Backup, restore, and how logs work.
Replication, logshipping, and mirroring.
Locking and deadlocking.
Performance monitoring and root cause troubleshooting. Four types of pressure: memory, cpu, disk, and network.
General query performance, query plan review, and indexing.
Development:
Generic SQL reading. Understand a UNION, LEFT/RIGHT/OUTER JOIN, and differences.
Function creation, Procedure Creation, View creation, indexed view creation and pros and cons, and parameterization.
Transaction controls and isolation levels
General query performance, query plan review, and indexing.
That will give you a baseline to start from.
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
November 7, 2010 at 7:28 am
Now... to get a "start" in SQL (and I do mean just a start... it takes a lot of practice to get really good at it), try www.w3schools.com . It's well done and lets you "try" SQL. I'm sure the others will have some decent tutorial recommendations, as well.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2010 at 6:20 am
Craig Farrell (11/7/2010)
sankarkot2007 (11/6/2010)
Hello Da-Zerodon't post these type of suggestions,ok.I learn beggener stage Thats why i want some questions
As Jeff mentioned above, that particular question is a trap. It implies someone looking to get a job without understanding the material. I understand your position, but don't ask for interview questions.
Ask something more like this:
"What are the first fundamentals I should concentrate on when looking to get involved in <type of position>?"
DBA:
Backup, restore, and how logs work.
Replication, logshipping, and mirroring.
Locking and deadlocking.
Performance monitoring and root cause troubleshooting. Four types of pressure: memory, cpu, disk, and network.
General query performance, query plan review, and indexing.
Development:
Generic SQL reading. Understand a UNION, LEFT/RIGHT/OUTER JOIN, and differences.
Function creation, Procedure Creation, View creation, indexed view creation and pros and cons, and parameterization.
Transaction controls and isolation levels
General query performance, query plan review, and indexing.
That will give you a baseline to start from.
I'd add a few to that.
For example, these days, I'd expect if you know Union, you should also know Intersect and Except.
I'd add Cross and Outer Apply to the expectation about Joins.
And before I'd worry about isolation levels, I'd want a dev to know about parameter sniffing and the drawbacks of table variables.
- 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
November 8, 2010 at 11:15 am
GSquared (11/8/2010)
For example, these days, I'd expect if you know Union, you should also know Intersect and Except.
I guess I need to learn intersects. 😉
And before I'd worry about isolation levels, I'd want a dev to know about parameter sniffing and the drawbacks of table variables.
Difference of opinion there I guess, Gus. I'd rather see intelligent and accurate resulting code before I want to see optimization. I can fix bad optimization, I can't fix data if it gets corrupted due to dirty reads expecting serialized information. Was thinking of a Junior here getting oversight, not necessarily thrown to the wolves.
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
November 8, 2010 at 12:45 pm
Craig Farrell (11/8/2010)
GSquared (11/8/2010)
For example, these days, I'd expect if you know Union, you should also know Intersect and Except.I guess I need to learn intersects. 😉
And before I'd worry about isolation levels, I'd want a dev to know about parameter sniffing and the drawbacks of table variables.
Difference of opinion there I guess, Gus. I'd rather see intelligent and accurate resulting code before I want to see optimization. I can fix bad optimization, I can't fix data if it gets corrupted due to dirty reads expecting serialized information. Was thinking of a Junior here getting oversight, not necessarily thrown to the wolves.
The reason I prioritize those over isolation levels is that, while I've rarely seen isolation level use other than adding "NoLock" to every table in a From clause, I see parameter sniffing and table variable issues constantly. And when it comes to cleaning up behind someone, search-and-replace can fix NoLock abuse, but not so much on table variables, et al.
If I wanted a quick-and-dirty "does he know T-SQL or is he just pretending" test, based on the minimum number of questions with the simplest answers, I'd ask about join syntax (including On vs Where for outer), table variables vs temp tables, and where an index scan is better than a seek. Might add in something about valid uses of cursors. If someone can answer intelligently on those first three, there's hope for them. If they just memorized stuff for an interview, the third question will almost certainly throw them. Switch that up with anything else that's the "exception to the rule" to sniff out other types of fakers. Anyone can memorize "seeks are better than scans", but only people who actually understand (at least a little bit) how both work can respond intelligently to a question about the opposite.
Just, if you do something like that, make it so the "trick" question isn't moronic. One place I interviewed last month, they asked when it would be okay to not be able to do point-in-time restoration on mission-critical data. I replied, "when the data is non-volatile during the interval between backups", but what they were looking for was justifying "when it's too expensive to run log backups and it's okay to lose a day's data". If the data is okay to lose, it is, by definition, non-mission-critical. Don't fall into that kind of trap.
- 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
November 9, 2010 at 12:22 am
sankarkot2007 (11/6/2010)
Hello Da-Zerodon't post these type of suggestions,ok.I learn beggener stage Thats why i want some questions
You are doing no good to the community by asking some set of questions to help you. Show respect.
By memorizing a question set you will do no good to you and the team you might join. Get a good hold of the basics. Self help and circumvention is the best I can suggest you.
Raunak J
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply