Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Aptitude tests

Author  Topic 

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2005-04-28 : 11:15:46
I'm looking for an aptitude test to set for new employees. MIS department, querying with Transact SQL. Really just testing logic, problem solving etc.

Can anyone recommend anything?

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-05-05 : 22:36:35
so you are looking for interview questions?

I have always liked this question: "How would you go about the task of counting all the chimneys in the United States?" Make sure you put that question in the middle of a bunch of technical questions though.

Another fun one to ask is "if you could be any animal, which animal would you be and why?" I like to end the interview with that one.

As for technical questions, they are just a quick google search away.


EDIT:
I remembered that Vyas had some questions on his site. Probabaly would be good to start with these: http://vyaskn.tripod.com/iq.htm



-ec
Go to Top of Page

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2005-05-06 : 03:36:47
I like the chimneys question

I was actually after a written test though rather than discussion points for interview. I found some examples online that test logic / problem solving, and one that tests Transact SQL knowledge but I just wondered if anyone had used one before / could recommend one.

Thanks for the link to the interview questions though. They all look strangely familiar from my last interview actually.

Em
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-05-06 : 05:22:59
i read in someone's blog that he asked the interviewee how would he desigh a spice shelf for the blind.
that's preety briliant if you ask me.
the point was that Braile is easier read if it is in a horizontal position than in a vertical position, so
a drawer would be better than a shelf.

Go with the flow & have fun! Else fight the flow
Go to Top of Page

jikki
Starting Member

1 Post

Posted - 2008-11-26 : 09:38:16
Check out these
[url]http://fresherswisdom.com/interview-questions/34-sql-server-2000.html[/url]
[url]http://fresherswisdom.com/interview-questions/23-database-management-systems.html[/url]
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-26 : 09:51:56
I like the answer Jeff Moden provided to the question "What is the fastest way to clear a table?"...




E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-11-26 : 09:54:05
and that was drop table?

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-26 : 10:41:08
No. He answered "A good fart"!



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-11-26 : 10:52:54
hahahaha

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!
Go to Top of Page

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2008-11-26 : 10:58:11
I like "How would you go about counting all the Libertarian votes in the United States?"
..
.
.
The answer, of course, is that Libertarian votes don't count.

If it is not practically useful, then it is practically useless.
Go to Top of Page

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-11-26 : 11:49:00
wow! i don't even remember asking that question in the first place but then it was 3 and a half years ago!!! thanks all the same jikki
...i wrote my own in the end by the way

Em
Go to Top of Page
   

- Advertisement -