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
 Old Forums
 CLOSED - General SQL Server
 Job interview with SQL Server Quiz - What to study
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

LaurieCox
Posting Yak Master

USA
146 Posts

Posted - 09/04/2006 :  16:36:21  Show Profile
Hi,

I have an interview for a job next week and as part of the interview I am to be given an SQL server Test/Quiz.

My main SQL background is in Oracle and DB2. I only worked for a couple of months with SQL Server (and that was last year).

My questions:

Has anybody taken an SQL job interview test? What kind of questions are asked?

Are there any differences between Oracle and SQL server that will bite me when answering questions (I know oracle does Joins differently) ...could there be anything else of that nature?

Are there any practice quizzes on the internet that I could take?

It's also been over six months since I’ve done database work so I need to brush up on my vocabulary as well, so I am looking for a list of terms to study. Besides the obvious ones like table, view, column, row, index, primary and foreign keys ... etc.


Thanks,

Laurie

rockmoose
SQL Natt Alfen

Sweden
3279 Posts

Posted - 09/04/2006 :  17:13:16  Show Profile
relation, relation variable, virtual, attribute, tuple, key, candidate ... etc.

100:1 you won't find them in the quiz...
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22744 Posts

Posted - 09/04/2006 :  20:58:19  Show Profile  Send madhivanan a Yahoo! Message
Make use of SQL Server help file

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17587 Posts

Posted - 09/04/2006 :  21:26:38  Show Profile
"Are there any practice quizzes on the internet that I could take?"
Here are some of them. Just Google for it
http://vyaskn.tripod.com/iq.htm
http://www.t-mug.org/Interview_SQL.aspx
http://www.geekinterview.com/Interview-Questions/Database/SQL-server-2000-interview-questions
http://sqljunkies.com/WebLog/joshcrosby/archive/2004/10/23/4754.aspx


KH


Edited by - khtan on 09/04/2006 21:28:40
Go to Top of Page

chiragkhabaria
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 09/05/2006 :  02:38:11  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message
one more added to the Tan's list

http://www.techinterviews.com/?p=280

Chirag
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17587 Posts

Posted - 09/05/2006 :  02:41:55  Show Profile
And something from the FAQ or FGA http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Interview


KH

Go to Top of Page

chiragkhabaria
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 09/05/2006 :  02:46:44  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message
yeah this post will be helpful when planning to shift job..

Chirag
Go to Top of Page

LaurieCox
Posting Yak Master

USA
146 Posts

Posted - 09/05/2006 :  12:07:36  Show Profile
Thanks everyone for your replies.

My Google skills must not be too great, I had only found the GeekInterview site (great site by the way).

I found a downloadable pop quiz there:

http://www.geekinterview.com/talk/105-sql-quiz-package-100-questions-free.html

... though it had some Oracle centric questions (some of it was useful), but one of my big concerns is that I will get something wrong because I use Oracle syntax instead of SQL server syntax.

I did find this page that seems to be the mother load of Oracle vs. SQL server differences:

http://www.akadia.com/services/sqlsrv2ora.html#_Toc513865430

It has almost too much information as I don't want to waste too much of my interview prep time trying to learn unnecessary things.

Anyway ... thanks again for your help and if anybody knows of any more places to find quizzes and info please let me know.

Thanks,

Laurie


Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000