OOPS concepts, mention a few object oriented programming languages
What are the access modifiers allowed for a constructor, Singleton design pattern
Write SQL query to find the user who logged in maximum number of times (table has entries with username, timestamp)
Round 3: Technical interview
n people play a tournament having a match with every other participant. Form a round Robin queue structure such that for a person at index i, he has lost to person at i-1 and won with i+1. It does not matter if he has lost or won with a person two or more indices away. (use bst traversal)
Give applications for (and the need of) each tree traversal
Write an SQL query to find the person who secured the second rank in class (and a few similar variants of such queries)