Oracle Financial Services Software Interview Questions and Answers

Duration : - 1 Hour
Platform : - Hackerrank
Topics : - REST API, SQL and DSA

Q1. How to create a table in SQL and elements to it.
Ans. 
To create a table in SQL, use the CREATE TABLE statement and define its elements.
• Use CREATE TABLE statement followed by table name

• Define columns with data types and constraints

• Add primary key constraint to uniquely identify each row

• Example: CREATE TABLE customers (id INT PRIMARY KEY, name VARCHAR(50), email VARCHAR(50))
Answered by AI
View 1 more answer
Q2. How to use JOIN operation on tables. Give an Example.
Ans. 
JOIN operation is used to combine rows from two or more tables based on a related column between them.
• JOIN can be used with different types like INNER, LEFT, RIGHT, FULL OUTER, etc.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

• JOIN can be used to fetch data from multiple tables in a single query.
Answered by AI
Add your answer

Q1. Bubble sort algorithm and how to optimize it.
Ans. 
Bubble sort repeatedly swaps adjacent elements if they are in wrong order.
• Bubble sort has a time complexity of O(n^2).

• It is not efficient for large datasets.

• Optimizations include adding a flag to check if any swaps were made in a pass and stopping if none were made.

• Another optimization is to keep track of the last swapped index and only iterate up to that index in the next pass.
Answered by AI
Add your answer
Q2. Balanced Parenthesis using Stack
Add your answer
Q3. Kth largest element in an array
Add your answer

Q1. Why OFSS ? How you are better than others?
Ans. 
OFSS is a leading consulting firm with a strong track record. I am better than others because of my skills, experience, and dedication.
• OFSS is a well-established and reputable consulting firm with a proven track record of success.

• I have a strong skill set and relevant experience that make me a valuable asset to OFSS.

• I am dedicated and committed to delivering high-quality results for clients.

• I have a track record of exc...read more
Answered by AI
Add your answer
Q2. Why you consider yourself fit for this role?
Ans. 
I am fit for this role because of my strong analytical skills, ability to work in a team, and experience in consulting.
• Strong analytical skills: I have a proven track record of analyzing complex problems and providing effective solutions.

• Ability to work in a team: I excel in collaborating with diverse teams to achieve common goals.

• Experience in consulting: I have previously worked as a consultant, gaining valuable expe...read more
Answered by AI
Add your answer

Had basic aptitude questions

Q1. General resume questions
Add your answer
Q2. What is bank reconciliation
Ans. 
Bank reconciliation is the process of comparing a company's records of its bank transactions with the bank's records.
• Bank reconciliation ensures that the company's financial records are accurate and up-to-date.

• It involves matching the transactions in the company's accounting system with those in the bank statement.

• Any discrepancies are identified and resolved, such as missing deposits or unauthorized withdrawals.

• Bank r...read more
Answered by AI
Add your answer
Q3. Tell me about GST
Ans. 
GST stands for Goods and Services Tax, a value-added tax levied on most goods and services sold for domestic consumption.
• Implemented in India in 2017 to replace multiple indirect taxes

• Helps in simplifying tax structure and reducing tax evasion

• Has different tax rates for different goods and services, such as 5%, 12%, 18%, and 28%

• Input tax credit can be claimed on taxes paid on inputs used in the production of goods or s...read more
Answered by AI
Add your answer

It was easy only, simple queue and array questions

Q1. Gave two queries , if you know java then its better. One was medium level and other was simple.
Add your answer
Q2. Write suffix as count in succession
Add your answer

Q1. Basic questions only.
Add your answer

Q1. Microservices - adv, disadv
Add your answer
Q2. Core java collections
Add your answer

Q1. Java 8 concepts with basic coding questions
Add your answer
Q2. Basic to medium Spring boot questions
Add your answer

Q1. Design a parking lot as part of the system design round.
Ans. 
Design a parking lot system with features like ticketing, payment, and space availability tracking.
• Create a class for ParkingLot with attributes like total number of spaces, available spaces, and ticketing system.

• Implement methods for issuing tickets, calculating parking fees, and updating space availability.

• Consider implementing a payment system for customers to pay for parking.

• Include features like tracking available...read more
Answered by AI
Add your answer

Q1. What are your reasons for wanting to switch jobs?
Ans. 
Looking for new challenges and opportunities for growth in a different environment.
• Seeking new challenges to continue learning and growing professionally

• Interested in working with new technologies and methodologies

• Desire for a change in company culture or work-life balance

• Opportunity for career advancement or higher compensation
Answered by AI
Add your answer