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.
| Author |
Topic |
|
LaurieCox
158 Posts |
 Posted - 2006-09-04 : 16:36:21
|
| 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
3279 Posts |
Posted - 2006-09-04 : 17:13:16
|
| relation, relation variable, virtual, attribute, tuple, key, candidate ... etc.100:1 you won't find them in the quiz... |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-04 : 20:58:19
|
| Make use of SQL Server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-05 : 02:46:44
|
yeah this post will be helpful when planning to shift job.. Chirag |
|
|
|
LaurieCox
158 Posts |
Posted - 2006-09-05 : 12:07:36
|
| 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: [url]http://www.geekinterview.com/talk/105-sql-quiz-package-100-questions-free.html[/url]... 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: [url]http://www.akadia.com/services/sqlsrv2ora.html#_Toc513865430[/url]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 |
|
|
|
|
|
|
|
|
Job interview with SQL Server Quiz - What to study