Oracle Associate Consultant interview questions

The interview process consisted of 4 rounds - online test(MCQs), 2 technical interviews and an HR interview. The online test was for about 2 hours and it consisted of 4 sections - verbal, software engineering, DBMS & OS and Coding skills (coding skills doesn't involve typing the whole code. It involves predicting what statement should be inserted in the code would give the necessary output). I got shortlisted for the face to face interviews which was held after 4 days from the online test. In first technical f2f they asked me questions about my projects in-depth. They also gave few queries which involves JOIN. They asked me basic OOPS concepts and OS concepts, and wanted to write a program as well. I got shortlisted for the 2nd technical round. During the 2nd technical round, they asked me about the flow of my project and again they asked me to write few queries. They also asked me to write few queries I used in my project. Basic OOPS concepts were asked. I got shortlisted for HR round. It was a general HR.