I attended interview in Lister - 2014 for the role of oracle developer. I just had two rounds of interview. I was asked about my previous work experience and projects worked .
Technical part was SQL queries and concepts like diff between rank dense rank etc
