I guess some sort of hierarchical queries are meant here. I.e. TREE_NODE table containing ID and PARENT_ID. You cannot query all parents of a given node using

I guess some sort of hierarchical queries are meant here. I.e. TREE_NODE table containing ID and PARENT_ID. You cannot query all parents of a given node using simple SQL.