Oracle Application-Engineer interview questions

Java Collections, Exceptions, SQL, JSON

1. Online test comprised of basic aptitude , verbal , logical and technical questions . Most of them were easy . 2.On paper-coding question was to find the smallest substring consisting of a,b,g characters . The other two questions were analytical to be specific . How will you put 50 RED and 50 BLUE balls in given two containers with infinite capacity , so that the probability of a ball taken out of the containers being red was maximum. I don't remember the other question. 3. T.I - I was mainly related to theoretical computer graphics , database and OS concepts like raster , random scan , cursor , pixel , resolution , dpi , ipc , normalization , nosql vs sql , thread architecture etc. 4. T.I -II , project discussion (interviewer 1) , deleting a node in heap (interviewer 2) , find nth highest salary in a table (interviewer 2), i wrote 4 queries to find the nth highest salary . Basically they test your overall knowledge of all your subjects and how strong your basics are. They dwell into deep intricacies of each subject to know the extent of your grasp on those subjects , plus your projects.