Oracle Financial Services Software Associate Consultant Interview Questions and Answers for Freshers

Q1. String reversal in Java
Add your answer
Q2. How would you resolve conflicts within the team?
Ans. 
I would address team conflicts by fostering open communication, understanding perspectives, and facilitating collaborative solutions.
• Encourage open dialogue: Create a safe space for team members to express their concerns and viewpoints.

• Active listening: Make sure to listen to all parties involved to understand their perspectives fully.

• Identify common goals: Remind the team of shared objectives to shift focus from perso...read more
Answered by AI
Add your answer

Arithmetic and basic OOPs

String reversal, core concepts of Java

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...read more
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. Basic general knowledge questions related to finance. E.g.Who is the RBI Governor of India,Full form of NSDL,Long and Put concept.
Add your answer

Q1. Conceptual and case study related questions.
Add your answer

Q1. There was 1 Tech and 1 HR round.
Add your answer
Q2. Tech interview was based on Java, DBMS concepts, Projects in resume
Add your answer