Oracle Associate Consultant interview questions

The overall process has three rounds Aptitude Test technical interview managerial interview overall process was good and moderate its an online process and more focused on projects and database queries also java

My Interview Experience R1 Little resume based (explain your best project first) She asked to rate yourself in Java and SQL 3/4 SQL Queries - diff b/w case and if then in sql - alter commands - update a value, without using this syntax ( update table_name set name=“abc” where id=1) simple dsa question: Reverse a string R2 Completely resume based, almost every thing on resume- internship,projects,achievements etc