Oracle Associate Technical Consultant interview questions

Had 2 rounds. First one and second one both being technical and managerial questions. More related to sql was asked. It was a good experience over all. Lot of members were there so it was handled well.

• How do you rate yourselves on SQL? • Asked some DDL Queries? Made a mistake and answered DML Queries instead. • Asked how do you select unique values from a column in SQL? • Asked how to select and display third, fourth and fifth largest values in a column? • Asked DS - Linked List, Queues & Pointers. Asked the memory management in Dynamic linked list then further asked to elaborate why is memory deallocation in heap is important while using pointers and Why is array implementation not used instead? • Asked Deadlocks and how to resolve them. Then asked bankers algorithm explanation. • Asked to do you know java? I said I don’t but can explain every OOPs concept in C++ instead. She didn’t ask any further.