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

  • Phil Factor

    SSCoach

    Points: 19959

    Comments posted to this topic are about the item Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

    Best wishes,
    Phil Factor
    Simple Talk

  • SQLRNNR

    SSC Guru

    Points: 281243

    Really surprised by the point value of this question.

    Good fundamental question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • george sibbald

    SSC Guru

    Points: 104200

    me too, but who's complaining? πŸ™‚

    ---------------------------------------------------------------------

  • SQLRNNR

    SSC Guru

    Points: 281243

    george sibbald (8/3/2014)


    me too, but who's complaining? πŸ™‚

    Me!! Take my points back. I protest!! :-D:hehe:;-)

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • mickyT

    SSChampion

    Points: 10360

    SQLRNNR (8/3/2014)


    george sibbald (8/3/2014)


    me too, but who's complaining? πŸ™‚

    Me!! Take my points back. I protest!! :-D:hehe:;-)

    Good question, but I think I'll keep mine:Whistling::-)

  • TomThomson

    SSC Guru

    Points: 104772

    Just like the others who have commented so far I think this is a good fundamental question which has ben assigned far too many points.

    Tom

  • twin.devil

    SSC-Insane

    Points: 22208

    Nice question, surprisingly too many people still fall for it if you ask them in a interview πŸ˜€

    Thanks for sharing Phil.

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    Great question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Ford Fairlane

    SSCertifiable

    Points: 7664

    TomThomson (8/3/2014)


    Just like the others who have commented so far I think this is a good fundamental question which has ben assigned far too many points.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • Carlo Romagnano

    SSC-Insane

    Points: 21873

    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.

    πŸ˜€

  • uravindarreddy

    Ten Centuries

    Points: 1389

    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

    SSC-Insane

    Points: 22076

    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.

    πŸ˜€

    +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 http://www.sqlservercentral.com/articles/Best+Practices/61537

  • Phil Factor

    SSCoach

    Points: 19959

    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

    SSC-Insane

    Points: 22208

    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

    One Orange Chip

    Points: 27737

    I just thought the easy Q & high points was an attempt to improve everyone's Monday morning πŸ™‚

    Can we do this every week?!

Viewing 15 posts - 1 through 15 (of 33 total)

You must be logged in to reply to this topic. Login to reply