|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Today @ 12:02 PM
Points: 5,243,
Visits: 7,055
|
|
|
|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 722,
Visits: 962
|
|
Fun question, definitely have to read ALL of the answers. Thanks!
Twitter: @SQLife Email: sqlsalt(at)outlook(dot)com
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:10 AM
Points: 1,239,
Visits: 346
|
|
Great question - thanks. Does make you think before answering, especially given the amount of information in the question.
|
|
|
|
|
SSCrazy Eights
        
Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,376,
Visits: 6,472
|
|
|
|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: Yesterday @ 1:51 AM
Points: 1,972,
Visits: 1,821
|
|
Great question. Hugo, you are the number ONE! Thanks.
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 3,129,
Visits: 4,312
|
|
Interesting question, Hugo, thanks. Requires carefull reading and thinking before answering...
____________________________________________ Space, the final frontier? not any more... All limits henceforth are self-imposed. “libera tute vulgaris ex”
|
|
|
|
|
Say Hey Kid
      
Group: General Forum Members
Last Login: Monday, March 11, 2013 4:12 AM
Points: 664,
Visits: 138
|
|
I don't think the answer is correct for the question (mentioed in screen shot).Because if you write like this , it will create a key that is treated as Primary Key and index wise it is clustered index
|
|
|
|
|
SSCrazy Eights
        
Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,376,
Visits: 6,472
|
|
|
|
|
|
SSChasing Mays
      
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:18 AM
Points: 643,
Visits: 688
|
|
Koen Verbeeck (6/14/2012)
amit_adarsh (6/14/2012) I don't think the answer is correct for the question (mentioed in screen shot).Because if you write like this , it will create a key that is treated as Primary Key and index wise it is clustered indexPlease read the question carefully: Below you see a part of a CREATE TABLE statement. -- More column and constraint definitions below
I missed that, d'oh what a douchebag, good question Hugo i'll look out for yours in future and spend a bit more time reading them
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Today @ 12:49 PM
Points: 7,102,
Visits: 7,163
|
|
Very good question.
The error rate so far (86% - 241 out of 280) is amazing. Most of those errors were the same wrong answer, there appears to a widely distributed myth that any primary index is clustered unless it is declared as unclustered. I knew that such a myth existed, but I thought it was so often debunked that only a small proportion of people still believed it. Well, that was clearly wrong - even though some of that 86% probably arises from carelessness in reading the question what is left after allowing for that carelessness is not a small proportion!
Tom Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
|
|
|
|