Oracle Financial Services Software Interview Questions, Process, and Tips

Q1. Java SQL Project related questions
Add your answer

20 questions, simple aptitude.

Q1. Btech Project, Binary tree traversal, OOPS concept
Add your answer
Q2. Difference between C++ and JAVA OOPs concept.
Ans. 
C++ supports multiple inheritance, Java supports single inheritance. C++ has pointers, Java has references.
• C++ supports multiple inheritance, Java supports single inheritance

• C++ has pointers, Java has references

• C++ does not have built-in garbage collection, Java has automatic garbage collection
Answered by AI
Add your answer

Q1. Given free time, what would you have done ?
Add your answer

Round duration - 150 minutes
Round difficulty - Hard

Oracle’s aptitude test is one of the longest aptitude tests I appeared for in my placement phase. It was around 2hrs 30mins long.
Questions were from basically every subject I had studied like OS, CN, SDLC, etc. Questions weren’t too hard but the difficult part about this test is that it was divided into sections and sub-sections.
Each sub-section had its own independent time interval so bringing it down to like 10 quant questions in 14 minutes might sound easy but it’s not. So managing time is the only difficult part of this round.

Q1. Which is the correct SQL query to select the top 5 numbers from the given data?
Ans. 
The correct SQL query to select the top 5 numbers from the given data is 'SELECT TOP 5 number FROM table_name ORDER BY number DESC'.
• Use the 'SELECT' statement to specify the columns you want to retrieve.

• Use the 'TOP' keyword followed by the number of rows you want to select.

• Specify the column name in the 'ORDER BY' clause to sort the data in descending order.
Answered by AI
Add your answer
Q2. 
AVL Tree Insertion Task
Create an AVL tree from scratch. You will be provided with ‘N’ values representing node values you need to insert into the AVL tree. After inserting all values, return the root of ...read more
Ans. 
The question asks to implement an AVL_TREE from scratch and insert given values into it.
• AVL_TREE is a self-balancing binary search tree

• The height difference between left and right subtrees of all nodes should not be more than one

• Implement the AVL_TREE data structure and insertion algorithm

• Return the root of the AVL_TREE after inserting all the nodes
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

The Technical Interview started off very fine and lasted for about 30-40 minutes. There were few HR questions in the beginning. The interviewer is very friendly. Firstly they asked me to tell them about myself. then the reasons for choosing this Profile. Then he asked me to explain the projects I have done. I have explained them. They have interrupted me and asked some doubts meanwhile. But I felt that they were intended just to check my confidence and how would I explain their doubts. They asked me some DSA Questions but I told them I am not much confident in DSA then they asked Basic Questions on DBMS like Explain about Normalization of DB, self Join, etc. And at the end, he asked me a general aptitude question based on Distance and time.

Overall the Interview was quite easy. Just learn the basics. Maintain good communication skills. Be confident and add good projects to your CV. Then it will be very easy to crack this round.

Q1. Can you write a SQL query to select specific data from a large collection?
Ans. 
Write a query to select data from a large collection.
• Use the SELECT statement to specify the columns you want to retrieve.

• Use the FROM clause to specify the table or tables from which to retrieve the data.

• Use the WHERE clause to specify any conditions that the retrieved data must meet.

• Use the ORDER BY clause to sort the retrieved data in a specific order.

• Use the LIMIT clause to limit the number of rows returned, if nec
Answered by AI
Add your answer
Q2. 
Find the Third Greatest Element
Given an array 'ARR' of 'N' distinct integers, determine the third largest element in the array.
Input:
The first line contains a single integer 'T' representing the numb...read more
Ans. 
The task is to find the third largest element in an array of distinct integers.
• Read the number of test cases 'T'

• For each test case, read the number of elements 'N' and the array 'ARR'

• Sort the array in descending order

• Return the element at index 2 as the third largest element
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

In the first 10 min, He asked me general HR questions like why OFSS. What are your strengths etc?
Then he asked me a puzzle. Then he asked me some questions from my resume regarding my internship and extracuriculars.
Then he asked me questions related to banking like how banks earn money, is a loan asset or liability, is FD asset or liability for a bank, and as I knew all these financial concepts already so it was quite easy for me to crack this round. The interviewer was very friendly and then I asked him some questions regarding the job profile and he answered every question happily and it was visible on his face that he is happy with my interview.

Q1. Describe your previous project experience
Add your answer
Q2. How does a Hashmap work
Ans. 
A Hashmap is a data structure that stores key-value pairs and allows for fast retrieval of values based on keys.
• Hashmap uses a hash function to map keys to indices in an array.

• It allows for constant time complexity O(1) for insertion, deletion, and retrieval operations.

• Collisions can occur when multiple keys map to the same index, which can be resolved using techniques like chaining or open addressing.

• Example: HashMap<...read more
Answered by AI
Add your answer
Q3. Explain Collection framework in Java
Ans. 
Collection framework in Java is a set of classes and interfaces that provide a standard way to store and manipulate groups of objects.
• Collection framework includes interfaces like List, Set, and Map, along with their respective implementations like ArrayList, HashSet, and HashMap.

• It provides methods to add, remove, and access elements in a collection, as well as perform operations like sorting and searching.

• Collections...read more
Answered by AI
Add your answer

Q1. Describe strength of your previous company
Add your answer
Q2. Reason for job change
Add your answer