Frage im Vorstellungsgespräch bei Informatica

Some basic Java questions, SQL-- queries regarding Joints, Was asked to write a Pseudocode with a Tree algorithm