Which of the following characteristics pertain to a “ragged” hierarchy?
A.
It can only be stored in an XML structure.
B.
It creates multiple levels of hierarchy in the databasetable.
C.
All values can have a maximum of six levels.
D.
A branch of the hierarchy may have a different number of levels than other branches.
Ans=D
Ragged Hierarchies are hierarchies where some routes down the hierarchy are longer than others; for example, you may have an organizational hierarchy for salespeople where the overall boss has two assistant managers, one of them works on their own and another has three sales managers under them; some of those sales manager may have sales staff under then, and some sales staff my have trainees under them.
D.
D.
http://www.rittmanmead.com/blog/2010/10/oracle-bi-ee-11g-skipped-ragged-hierarchies-grouping-sets-grouping-ids/