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

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

Linked list graph string to be prepared

Graph linked list was asked in this round

Q1. Salary negotiation
Add your answer

Q1. Rate yourself in the technology that you have added in your skills.
Add your answer

Q1. Basic Questions of Data structure
Add your answer
Q2. 2 Sum
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