Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it? Expand / Collapse
Author
Message
Posted Monday, August 4, 2014 1:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 18, 2014 11:21 PM
Points: 374, Visits: 339
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.

Post #1599138
Posted Monday, August 4, 2014 1:29 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 10:13 AM
Points: 1,268, Visits: 4,146
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
Post #1599140
Posted Monday, August 4, 2014 1:44 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, December 12, 2014 11:01 AM
Points: 594, Visits: 2,580
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
Post #1599142
Posted Monday, August 4, 2014 1:52 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:33 AM
Points: 856, Visits: 1,506
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
Post #1599145
Posted Monday, August 4, 2014 3:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:37 AM
Points: 2,114, Visits: 3,719
I just thought the easy Q & high points was an attempt to improve everyone's Monday morning
Can we do this every week?!
Post #1599168
Posted Monday, August 4, 2014 4:14 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:53 PM
Points: 1,431, Visits: 687
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
Post #1599181
Posted Monday, August 4, 2014 4:16 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, September 18, 2014 2:30 AM
Points: 595, Visits: 219
Got some energy for Monday
Post #1599183
Posted Monday, August 4, 2014 5:12 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 11:20 AM
Points: 4,618, Visits: 4,072
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
Post #1599200
Posted Monday, August 4, 2014 6:26 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:08 AM
Points: 4,160, Visits: 5,557
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”
Post #1599224
Posted Monday, August 4, 2014 6:39 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 20, 2014 4:29 AM
Points: 3,559, Visits: 2,671
Good question.
Post #1599230
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse