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


HierarchyID Trees


HierarchyID Trees

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: 10091 Visits: 1
Comments posted to this topic are about the item HierarchyID Trees
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)

Group: General Forum Members
Points: 9438 Visits: 9517
In a tree repesentated by the hierarchy id, nodes are shown as /1/, /1/1/, /1/2/, /1/2/3/, etc. In this representation, what would the "2" repesent?
Choose your answer:
Nodes at the same level
Nodes in the same subtree
No particular meaning.

The answers listed make no sense in the context of the question asked.

The question is "..what would the "2" represent?" "2" is a singular item, that is not in comparison with anything in the question.

"Nodes at the same level" and "Nodes in the same subtree" are both plural nouns that draw a comparison between the multiple implied items. They cannot be the correct answer to the question because there is nothing in the question for "2" to be "at the same level" as or "in the same subtree" as.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Christian Buettner-167247
Christian Buettner-167247
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2949 Visits: 3889
Can someone please explain this to me?

As far as my knowledge goes, the following tree
represents a possible implementation of the tree
posted by the author. Node /1/1/2/ has been
added since the author specified an incomplete
tree (as he used "etc.")
1
/ \
1 2
/ \
2 3

This should totally invalidate the proposed answer,
since "2 "(left side) is not in the same subtree tree
as "2" (right side).

Or did I miss something?

Thanks!

Best Regards,

Chris Büttner
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: 36085 Visits: 18738
There are 2 2's in the question example, so those are being compared.

In the representation, as Christian has shown, there could be two places 1/1/2 could be. However if I gave you two examples and asked to compare, they're both representing the same way. So the 2's would be at the same level. There would need to be a representation that showed how you break the left and right branches.

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
Christian Buettner-167247
Christian Buettner-167247
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2949 Visits: 3889
Hi Steve,

What you are saying is, that the question was about
/1/, /1/1/, /1/2/, /1/2/3/

and not about
/1/, /1/1/, /1/2/, /1/2/3/, etc.
?

Thanks!

Best Regards,

Chris Büttner
Sioban Krzywicki
Sioban Krzywicki
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1134 Visits: 8067
I realize this is an old question, but I'm killing time while waiting for a remote install to finish. This is a terribly worded question. The correct answer is that the 2 represents the second entry on the second level. As for the answers, it represents a node at the same level as it is the second node at a level. It also represents the parent of nodes in the same subtree, not the nodes themselves. The answer given, while one of three bad answers, is not the best response of those available.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
TomThomson
TomThomson
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: 10704 Visits: 12001
Stefan Krzywicki (2/5/2010)
I realize this is an old question, but I'm killing time while waiting for a remote install to finish. This is a terribly worded question. The correct answer is that the 2 represents the second entry on the second level. As for the answers, it represents a node at the same level as it is the second node at a level. It also represents the parent of nodes in the same subtree, not the nodes themselves. The answer given, while one of three bad answers, is not the best response of those available.

I too am killing time, and reckon that this question and answer are appallingly bad. Essentially I agree with Stefan. The occurrences of "2" in the list of representations all represent the same node (the second node on the second level) which is not any of the options provided - all of which are wrong. Probably the answer given is the worst of the three wrong answers provided.

Tom

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