Oracle Financial Services Software Senior Application Engineer Interview Questions and Answers

Q1. Related HVAC controlling
Add your answer
Q2. Relating AHU controlling
Add your answer

Asked quant and reasoning and English

Q1. What is normanlization
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down data into smaller, more manageable tables

• It helps in reducing data redundancy by storing data in a structured manner

• Normalization ensures data integrity by minimizing data anomalies

• There are different normal forms such as 1NF, 2NF, 3NF, BCNF, etc.
Answered by AI
Add your answer
Q2. Types of normalisation
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Types of normalization include 1NF, 2NF, 3NF, BCNF, and 4NF.

• 1NF (First Normal Form) ensures that each column contains atomic values.

• 2NF (Second Normal Form) eliminates partial dependencies by ensuring all non-key attributes are fully functionally dependent on the primary key.

• 3NF (Third Normal Form) eliminates t...read more
Answered by AI
Add your answer

Q1. Technology support questions about work
Add your answer

Q1. 2nd largest element in array
Ans. 
Find the 2nd largest element in an array of strings.
• Sort the array in descending order

• Access the element at index 1 to get the 2nd largest element
Answered by AI
Add your answer
Q2. Top view of given binary tree
Ans. 
To get the top view of a binary tree, we need to find the nodes that are visible when looking at the tree from the top.
• Start from the root node and assign it a horizontal distance of 0.

• Traverse the tree using a queue and keep track of the horizontal distance of each node.

• For each horizontal distance, only keep the node with the smallest level in the result.

• Repeat the process for left and right child nodes, updating the
Answered by AI
Add your answer

Q1. Questions related to iOS and swift basics
Add your answer
Q2. Design NotificationCenter
Ans. 
NotificationCenter is a system that enables communication between different parts of an application.
• NotificationCenter allows components of an application to communicate without having direct references to each other.

• It uses the observer pattern where objects register themselves as observers for specific notifications.

• Notifications can be posted to the NotificationCenter with optional data.

• Observers can then receive an...read more
Answered by AI
Add your answer

Q1. Design twitter feed & solid principles
Ans. 
Design a Twitter feed using SOLID principles
• Separate classes for each responsibility (Single Responsibility Principle)

• Use interfaces to define behavior and allow for easy swapping of implementations (Open/Closed Principle)

• Dependency Injection to decouple components and make testing easier (Dependency Inversion Principle)

• Liskov Substitution Principle to ensure derived classes can be substituted for their base classes wi...read more
Answered by AI
Add your answer

Q1. It was hiring manger rounds .. Behavioural questions
Add your answer
Q2. First occurence of given number in sorted array
Ans. 
Find the first occurrence of a given number in a sorted array.
• Use binary search to efficiently find the first occurrence of the number.

• Keep track of the index of the first occurrence as you search through the array.

• Return the index of the first occurrence once found.
Answered by AI
Add your answer

Q1. Project explanation,security concept question,integration basics,what are debug logs
Add your answer
Q2. Lwc lifecycle hooks and one trigger to code
Add your answer

Q1. How to use JAVA code in Oracle BPEL
Ans. 
To use JAVA code in Oracle BPEL, you can create a Java Embedding activity within a BPEL process.
• Create a Java Embedding activity within the BPEL process

• Write the Java code within the Java Embedding activity

• Compile the Java code and deploy the BPEL process
Answered by AI
Add your answer
Q2. Explain Integration BPM human task with SOA
Ans. 
Integration of BPM human task with SOA involves connecting business processes with service-oriented architecture.
• BPM human task defines the steps and actions required for a specific task in a business process.

• SOA is an architectural style that enables the creation of loosely coupled, reusable services.

• Integration involves connecting the human tasks defined in BPM with the services in SOA to automate and streamline busi...read more
Answered by AI
Add your answer

Q1. Complex scenario solved during your current job
Add your answer

Q1. Related HVAC controlling
Add your answer
Q2. Relating AHU controlling
Add your answer