Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


HierarchyID


HierarchyID

Author
Message
Site Owners
Site Owners
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: 10095 Visits: 1
Comments posted to this topic are about the item HierarchyID
Jamie-2229
Jamie-2229
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2955 Visits: 831
For me, this was a great question. The Microsoft link explains the properties in a concise and understandable way and the meat of what it explains is actually also the answer to this question. Kudos to the questions' creator.

Jamie
gdelgado
gdelgado
SSC-Enthusiastic
SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)

Group: General Forum Members
Points: 161 Visits: 129
I got the answer right, but i still think "i is less deep in the tree than j" is just as good an answer. I just figured theyd want to hear the more complicated way of saying it.
Jamie-2229
Jamie-2229
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2955 Visits: 831
After taking a few MS Certification exams, I have noticed that many questions tend to ask a question and provide a multiple choice answer that allows more than one answer to be correct. It may just be a current technology among educators to test someone's ability to discern the best answer rather just any answer. It makes the tests more difficult.

Jamie
Nick W*
Nick W*
SSC-Enthusiastic
SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)

Group: General Forum Members
Points: 130 Visits: 180
Consider the following
o
/ \
o i
/
j

I is less deep than J, yet in a 'depth first' search, it may not necessarily come before J in a search.. Only in a BREADTH-FIRST search would I ALWAYS come before J.....

In a depth-first search their ordering is indeterminate unless i is one of j's ancestors.
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36172 Visits: 18751
In that diagram, correct, but if I < J, then it would come before it.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Nick W*
Nick W*
SSC-Enthusiastic
SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)

Group: General Forum Members
Points: 130 Visits: 180
Hi Steve, thanks for the response, but I was tackling Jamie and gdelgado's agreement that both phrases

"In a depth-first traversal, node i comes before node j"
and
"I is lower in the tree than J"

are equivalent but one is 'worded nicer' and therefore the 'accepted answer'.

I was presenting a counter-case where one was true and the other wrong to show that they aren't just equivalent, but in fact your question was subtle and the answers weren't word-play tricks a-la MCSE questions.

Smile
Jamie-2229
Jamie-2229
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2955 Visits: 831
but in fact your question was subtle and the answers weren't word-play tricks a-la MCSE questions.


If my meaning was that it was intended to be a trick question, then this is true. Reflecting back, I think I made the testing allusion because I was thinking at the time that how this particular question clearly reflected the concept of breadth first vs depth first and was indeed, NOT tricky. My comment history would probably reflect that I tend to think the questions are tricky at times. In this case, however; I am applauding the author on writing one that gave more clarity to a lesser known concept.

Jamie
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