SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Is a foreign key constraint an index? If not, is an index automatically created in order to enforce...


Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

Author
Message
uravindarreddy
uravindarreddy
Right there with Babe
Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)

Group: General Forum Members
Points: 787 Visits: 658
Hi,
Yeah this is a very straightforward question but in the context of SQL Server. But will be bit confusing to those who work on other RDBMS products such as MySQL InnoDB. But, for those who work rigorously on MS SQL Server this is just a straightforward question worth of 1 point.
Neil Burton
Neil Burton
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12144 Visits: 11432
Carlo Romagnano (8/4/2014)
I read question and answers many times because of high score.
I was searching for the swindle!
But it's only a straightforward basic question.
:-D


+1

I thought I knew what the answer was as soon as I read the question, then I saw the points value and wondered what the catch was. After a load of research and reading round I found out I was right after all.


On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help
Phil Factor
Phil Factor
SSCrazy Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: General Forum Members
Points: 9511 Visits: 3085
I'm sorry if it got scored too high, but when I ask this as part of a technical interview, it seems to stump a very large proportion of the candidates. I suspect that it is one of those questions that are either blindingly obvious or impenetrably baffling. And, yes, it could be a trick question for anyone used to some of the other RDBMSs


Best wishes,

Phil Factor
Simple Talk
twin.devil
twin.devil
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12312 Visits: 2898
Phil Factor (8/4/2014)
I'm sorry if it got scored too high, but when I ask this as part of a technical interview, it seems to stump a very large proportion of the candidates. I suspect that it is one of those questions that are either blindingly obvious or impenetrably baffling. And, yes, it could be a trick question for anyone used to some of the other RDBMSs

+1000
Gazareth
Gazareth
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15811 Visits: 6113
I just thought the easy Q & high points was an attempt to improve everyone's Monday morning :-)
Can we do this every week?!
Hany Helmy
Hany Helmy
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7257 Visits: 1122
Gazareth (8/4/2014)
I just thought the easy Q & high points was an attempt to improve everyone's Monday morning :-)
Can we do this every week?!

+ 1 :-)
Jamsheer
Jamsheer
SSC Eights!
SSC Eights! (833 reputation)SSC Eights! (833 reputation)SSC Eights! (833 reputation)SSC Eights! (833 reputation)SSC Eights! (833 reputation)SSC Eights! (833 reputation)SSC Eights! (833 reputation)SSC Eights! (833 reputation)

Group: General Forum Members
Points: 833 Visits: 237
Got some energy for Monday :-)
Ed Wagner
Ed Wagner
SSC Guru
SSC Guru (157K reputation)SSC Guru (157K reputation)SSC Guru (157K reputation)SSC Guru (157K reputation)SSC Guru (157K reputation)SSC Guru (157K reputation)SSC Guru (157K reputation)SSC Guru (157K reputation)

Group: General Forum Members
Points: 157281 Visits: 11663
Good way to start the week. I'm one of those who read the question and found it obvious, but had to re-read it because of the point value. I'm certainly not complaining. Thanks for the question, Phil.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35416 Visits: 7702
TomThomson (8/3/2014)
Just like the others who have commented so far I think this is a good fundamental question which has been assigned far too many points.


+1
Good one, thanks Phil

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
sqlnaive
sqlnaive
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10945 Visits: 2774
Good question. :-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search