Oracle | Senior Application Developer

I have applied on Naukri for the Oracle Openings.

Hackerrank OA

The recruiter reached out to me giving a Hackerrank OA. I have completed that OA and the questions are mentioned here: link

<hr>

Round 1(On-site)

My on-site interview was divided into two parts. The first part focused on Java Core, Data Structures and Algorithms (DSA), Math Puzzles, and previous work experience. The second part was entirely dedicated to Database Management and SQL queries. The questions included:

Java Core:

How does immutability works in java?
How to create an immutable class?
Can a class be static? If yes, then where it can be used?
Difference in C++ and Java.
How does string addition work in Java?(s1 = s1+s2)
In which case does the finally block does not execute?

DSA:

Get the Longest Valid Parentheses sequence.
Example: For the string "((())()()", the answer would be 8, which corresponds to "(())()()".

Math Puzzles:

Last Palindrome Date (gfg puzzle)
Three boxes have two balls inside. One with two green, one with two red and one with 1 red & 1 green. All the boxes are labelled as GG, RR and RG. What if I change all the labels to be incorrect, like GG labelled box will never have 2 green ball, it would either have 2 red balls or 1 green and 1 red ball. Now we have to take out one ball from any of the box of our choice and have to tell what are the right label for all of the boxes.
Door Puzzle (Classic puzzle on gfg)

DB and SQL:

There were some questions on Hibernate on how it works?
Queries on Cartesian Product, Full Join, left Join.
Lazy Loading in Spring Boot
@Transaction Management in Hibernate.
Some questions on Indexing.
Primary Key vs Unique Key
Having vs Where clause
Normalization upto 3NF
Read and Write locking in DB.

<hr>

Round 2(Online)

After this Round, an online interview was scheduled where the interviewer asked me all the questions regarding my previous projects, this round went on for 45 min. He is trying to get if I know about my project in depth or not. One more weird thing happened where the technical interviewer asked for my salary expectations instead of the recruiter and he was very keen in knowing the exact compensation that I am having right now, he was not ready to take a range of number(found it very weird).

<hr>

Result

The interviewer from the second round mentioned that I would receive feedback within 3-4 days. However, it has been two weeks without any communication from the recruiter. I have reached out several times but have not received any response