Optum Global Solutions Software Engineer Interview Questions, Process, and Tips

It was a standard and pretty easy one

Q1. Why do you want to join
Add your answer
Q2. Very professional HR
Add your answer

String manipulation questions

Q1. Array search and sorting
Add your answer

Q1. What are constructors in dot net core and how will you overload a constructor.
Ans. 
Constructors are special methods used to initialize objects. Overloading allows multiple constructors with different parameters.
• Constructors have the same name as the class and no return type.

• Overloading constructors allows for different ways to initialize objects.

• Example: public class Person { public Person(string name) { } public Person(string name, int age) { } }

• Overloaded constructors can call each other using the
Answered by AI
Add your answer
Q2. How to make restrict a class so that it can not be inherited
Ans. 
To restrict a class from being inherited, mark it as final.
• Use the final keyword before the class declaration.

• Final classes cannot be subclassed.

• Any attempt to subclass a final class will result in a compile-time error.
Answered by AI
Add your answer
Q3. What are constraints in Sql
Ans. 
Constraints in SQL are rules that limit the type of data that can be inserted, updated or deleted from a table.
• Constraints ensure data integrity and consistency.

• Types of constraints include primary key, foreign key, unique, check, and default constraints.

• Examples of constraints include ensuring a column cannot have null values, or ensuring a foreign key references a valid primary key.

• Constraints can be added when creat...read more
Answered by AI
Add your answer

Q1. Tell me about yourself and the work you have done in recent times.
Ans. 
I am a software engineer with experience in developing web applications using Java and JavaScript.
• Developed a web application using Java Spring framework

• Implemented RESTful APIs for data retrieval and manipulation

• Utilized JavaScript frameworks like React.js for front-end development

• Worked on database design and optimization using SQL

• Collaborated with cross-functional teams to deliver high-quality software
Answered by AI
Add your answer
Q2. What new technology have you learned in last 6 months.
Ans. 
I have learned about React Native in the last 6 months.
• I have learned how to build mobile applications using React Native.

• I have learned about the different components and libraries available in React Native.

• I have also learned how to integrate React Native with other technologies like Firebase.

• For example, I built a mobile app for a client using React Native and Firebase for real-time data updates.
Answered by AI
Add your answer

Q1. What are the features of Java 8?
Ans. 
Java 8 introduced significant features like lambdas, streams, and the new Date-Time API, enhancing productivity and code readability.
• Lambda Expressions: Enable concise representation of functional interfaces. Example: (a, b) -> a + b.

• Streams API: Facilitates functional-style operations on collections. Example: list.stream().filter(x -> x > 10).collect(Collectors.toList()).

• Default Methods: Allow interfaces to h...read more
Answered by AI
Add your answer
Q2. What is the process for implementing a linked list?
Ans. 
Implementing a linked list involves defining nodes, linking them, and providing methods for insertion, deletion, and traversal.
• Define a Node class with data and a pointer to the next node.

• Create a LinkedList class to manage the head node and operations.

• Implement methods for insertion (at head, tail, or specific position).

• Implement methods for deletion (by value or position).

• Provide traversal methods to display the list
Answered by AI
Add your answer

Q1. What is an IoC (Inversion of Control) container?
Ans. 
An IoC container manages object creation and dependencies, promoting loose coupling and easier testing in software applications.
• IoC containers handle the instantiation and lifecycle of objects, reducing manual dependency management.

• They support Dependency Injection (DI), allowing dependencies to be provided externally rather than hard-coded.

• Examples include Spring Framework (Java), .NET Core's built-in IoC container, a...read more
Answered by AI
Add your answer

Q1. What is Procedure and package
Ans. 
Procedure and package are two types of database objects used in Oracle database.
• A procedure is a subprogram that performs a specific action and can be called by other programs.

• A package is a collection of related procedures, functions, and variables that can be used by multiple programs.

• Procedures and packages are stored in the database and can be called from any program that has access to the database.

• Procedures and p...read more
Answered by AI
Add your answer
Q2. View and materilzed view differences
Ans. 
View is a virtual table while Materialized view is a physical table.
• View is a logical representation of data while Materialized view is a physical copy of data.

• View is updated dynamically while Materialized view needs to be refreshed manually.

• Materialized view is faster for read-heavy operations while View is better for write-heavy operations.

• Materialized view can be indexed while View cannot be indexed.
Answered by AI
Add your answer

Q1. Database types and standards
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Question related to your technology
Add your answer