Oracle Interview Experience | Senior Application Developer | Selected
Summary
I interviewed for a Senior Application Developer role at Oracle across multiple rounds, including technical, managerial, and techno-managerial discussions, and was ultimately selected.
Full Experience
Oracle Interview Experience - Senior Application Developer
The HR found the profile from Naukri. Received a call from HR for the onsite interviews.
Round 1 (onsite) -
1) Given a string, write a function to encode and decode it. The encode string should not be easily decoded by naked eyes.
2) Binary Tree Maximum Path Sum
Round 2 (onsite) -
1) Given a string of binary bits, find all the substrings which are repeating consecutively and the no of times its repeated. The repeating string length should be greater than 2.
eg:-
Given String - "010110111"
o/p -
101 -> 2
011 -> 2
2) Maximum Subarray
Round 3 (onsite) -
It more of a managerial round, the interviewer asked few questions related to my current work. He later gave me one question.
Given a date and the no of days, what will be the date after adding the given no of days. The days can be very large as well. He gave me days as 1000.
eg - 01/03/2025 , days = 20
o/p - 21/03/2025
Round 4 (virtual) -
This was a techno-managerial round.
He asked me questions related to my resume and few behavorial questions. He also asked 1 easy DSA question and 1 sql query.
DSA question -
Given the list of numbers, find the all possible combinations from given input which can have a target sum as 220.
SQL query -
Given a table:
(emp_id, date of salary, salary amount)
Find the employee who has until now received a total amount > 1000000
After couple of days received a call from HR and she confirmed that I am selected. Waiting for the offer letter :)
Interview Questions (7)
Encode and Decode String
Given a string, write a function to encode and decode it. The encode string should not be easily decoded by naked eyes.
Binary Tree Maximum Path Sum
Find Repeating Binary Substrings
Given a string of binary bits, find all the substrings which are repeating consecutively and the no of times its repeated. The repeating string length should be greater than 2.
eg:-
Given String - "010110111"
o/p -
101 -> 2
011 -> 2
Maximum Subarray
Add Days to Date
Given a date and the no of days, what will be the date after adding the given no of days. The days can be very large as well. He gave me days as 1000.
eg - 01/03/2025 , days = 20
o/p - 21/03/2025
Find Combinations for Target Sum
Given the list of numbers, find the all possible combinations from given input which can have a target sum as 220.
SQL Query: Employees with Total Salary > 1,000,000
Given a table:
(emp_id, date of salary, salary amount)
Find the employee who has until now received a total amount > 1000000