Oracle Software Developer interview questions

First was asked about basic dsa concepts and understanding of that Then proceeded with basic questions just as palindrome, prime numbers etc Then proceeded with questions on sql like joins etc Later was asked questions about aptitude thinking and logical questions

A problem statement was given to build a predictive model to help a CFO of an IT company to predict the time taken by an issue to resolve and classify the issue to high and low priority. Give some insights on the dataset to reduce the time to resolve the issue