Sqlserver 2005 exam

Question

Sqlserver 2005 exam

karthik M

One Orange Chip

Points: 29139
More actions
August 31, 2007 at 10:20 am

#180750

Hi all,

I like to write sqlserver2005 exam. But i dont know from where to start ? how to prepare ? do anybody have material to read , if yes please send it to me.
Regards
Karthik

karthik

Viewing 6 posts - 1 through 5 (of 5 total)

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

David McFarland SSChampion Points: 11815 More actions · Answer 1

It depends on the purpose of your exam.

If you want to create practice exams to be used for certification purposes then get a bunch of people to take the exam and unload everything they remember once they are done.

If you want to test someone's SQL Server 2005 knowledge for a job interview, I'd first look at what skills would be needed to perform their job functions (no need to require a clustering expert if you will never need a clustering expert, for instance), and then test them in those areas specifically.

If you just want a large, varied test, covering all aspects of SQL Server 2005, I'd just get a variety of books, especially ones that test your knowledge after each chapter, and pick and choose as desired.

Whatever the need, you need to allow for some form of feedback. Many of us have grown really tired of being given crappy tests that have multiple correct answers, no correct answers, or the wrong "correct" answer. Don't be the guy who writes those tests.

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 2

I've got to agree with David... I'm sick and tired of exams that have been written by folks that are simply not qualified to write exams. That includes the things that David mentioned like having multiple correct answers, no correct answers, or the wrong correct answer. I'll also add that people that write "trick" questions have no interest in what a person knows about SQL and are more impressed with themselves.

If you must test someone, hand them a couple of simple problem descriptions and have them write code (that IS what you want them for, right????) ... tell them to write it as if it were final production code (and give them a reasonable amount of time to do it to their best)... you'll learn a lot about how they style the code for readability, how they document the code, and whether or not they trully know SQL or not.

If the test is for interviews, I normally have one recommendation... forget it... if the person doing the interview can't get a feel for how much the person being interviewed actually knows about SQL during a technical interview, then the person doing the interview is the wrong person to be doing the interview. Further, technical testing is grossly impersonal... you learn nothing of the persons temperment, personality, attidtude, or ability to communicate by having them take a multiple choice test...

... and, attitude is the key in most cases... I'd much rather hire someone that's a little short on SQL but has a good work ethic and is willing to learn than some "Prima Donna" "know-it-all" that thinks (s)he is God's gift to the world of programming.

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

Vladan SSC-Insane Points: 22072 More actions · Answer 3

Maybe this is just misunderstanding and karthikeyan just wants to TAKE exam and is asking how to learn for it? I seem to remember that he stated about himself a few days ago that he is beginner, so I doubt he would be wanting to create tests for an exam.

karthikeyan,

If you really asked how to write questions for a test, then I strongly suggest to reconsider it. Tests should be written by those who KNOW how to do it - if tests are necessary at all (I agree with Jeff and David absolutely, there are better ways to find out about SQL skills).

Eddie Wuerch SSChampion Points: 12535 More actions · Answer 4

I have heard a number of (non-American) folks who refer to taking an exam as 'writing' the exam. The OP was merely asking about getting started.

Karthikeyan: you can get started here:

http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx

...which contains details on exam 70-431. This exam will earn you the MS Certified Technical Specialist (MCTS) on SQL Server 2005 certification, and is required for both the developer or administrator premium certifications.

-Eddie

Eddie Wuerch
MCM: SQL

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 5

Never heard that, Eddie, but I'll be on the lookout for that from now on... one more chip taken from the language barrier. Thanks.

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