first is assessment is based on luck difficult and this is online and the interview (tech,HR) rounds are easy. and this is offline. tech is average decides by panel who will come and the HR is taken by HR consist of again technical questions easy but
Interview questions [1]
Question 1
Q:Sql for counting all ages person with each age count
I applied through college or university. The process took 2 days. I interviewed at Oracle in Aug 2023
Interview
There was an online coding assignment on Hackerrank, and after that, students were shortlisted for an interview. There were three rounds of technical discussions and 1 HR round. There were three different technical teams for every game and other HR teams.
Interview questions [1]
Question 1
The question was a mix of OS, OOPS, DSA, and CN. They also asked about my internship experience. The OS questions were fundamental, like deadlock and explaining why it occurred. The DSA question I got was about Implementing a stack using two queues. And queue using two stacks. After that, a few more basic string questions. Now, coming to CN, one team went into depth about it, while the other didn't even ask for it.
Interview was good. Asked about the technical skills. Data structures and algorithms, Data base management system, SQL. Interview was of 3 rounds.2 technical and 1 HR. It was a part of our on campus intership opportunity