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

  • 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

  • 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

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

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

  • 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

  • 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::-)

  • 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

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

    Thanks for sharing Phil.

  • Great question, thanks.

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

  • 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

  • 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.

    πŸ˜€

  • 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.

  • 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

  • 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

  • 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

  • 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