SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 Other Topics
 Aptitude tests
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 04/28/2005 :  11:15:46  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 05/05/2005 :  22:36:35  Show Profile  Reply with Quote
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

Edited by - eyechart on 05/05/2005 22:40:26
Go to Top of Page

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 05/06/2005 :  03:36:47  Show Profile  Reply with Quote
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

Slovenia
11750 Posts

Posted - 05/06/2005 :  05:22:59  Show Profile  Visit spirit1's Homepage  Reply with Quote
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

India
1 Posts

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

SwePeso
Patron Saint of Lost Yaks

Sweden
30115 Posts

Posted - 11/26/2008 :  09:51:56  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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

Slovenia
11750 Posts

Posted - 11/26/2008 :  09:54:05  Show Profile  Visit spirit1's Homepage  Reply with Quote
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

Sweden
30115 Posts

Posted - 11/26/2008 :  10:41:08  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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

Slovenia
11750 Posts

Posted - 11/26/2008 :  10:52:54  Show Profile  Visit spirit1's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 11/26/2008 :  10:58:11  Show Profile  Reply with Quote
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.

Edited by - blindman on 11/26/2008 10:58:35
Go to Top of Page

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 11/26/2008 :  11:49:00  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000