Oracle Associate Consultant interview questions

There were 2 rounds for me , mainly focused on DSA and project discussion Online assessment 32 Questions in total 1. Coding : Given two string s , t , find the first index of t in s ( KMP based solution ) as constraints were tight 2.SQL: Easy 3- 30: Questions based on OOPS , DBMS , some questions of LR , Apti ___________________ Provide Personal Interview experience. List out the questions asked in personal interaction round. * There we 2 rounds for me Round 1 : DSA Questions based on priority queue , Indepth project discussion Round 2 (HR+TECH) : Some general hr questions , Asked to draw ER diagram of my project , Indepth project description _______________ Technical Database This is section deals with collection of technical questions asked during interviwes. Provide the list of technical questions asked during the interview (technical subject related) * Basics OOPS , DBMS Query (2nd highest salary ) Questions on technical terms written on project description ________ Provide the list of programming questions asked during the selection process. Also mention the programming language. * 1.Find the sum of top k elements in priority queue 2. Design Priority Queue using array