Optum
10+ BEO Software Interview Questions and Answers
You have been given two integers ‘X’ and ‘Y’ which are the first two integers of a series and an integer ‘N’. You have to find the Nth number of the series using the Fibo...read more
Given a string ‘STR’ which consists of uppercase and lowercase characters and spaces. Count the number of consonants in the string.
A consonant is an English alphabet character that ...read more
You are given two sorted linked lists. You have to merge them to produce a combined sorted linked list. You need to return the head of the final linked list.
Note:
The given linked ...read more
You are given an integer ‘NUM’ . Your task is to find out whether this number is an Armstrong number or not.
A k-digit number ‘NUM’ is an Armstrong number if and only if the k-th power of each d...read more
Three DBMS questions were asked: -
1. Difference between delete, truncate, drop commands
2. Explain the concept of various types of keys used in DBMS along with examples
3. Queries including group by a...read more
Asked me about the concepts of OOPS. Asked me to implement classes and objects. Then asked me to implement inheritance. Asked the difference between overloading and overriding and asked to im...read more
Q7. How to make restrict a class so that it can not be inherited
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.
Q8. What are constructors in dot net core and how will you overload a constructor.
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 'this' keyword.
Q9. Arrange the array in decreasing order without extra space and without sort function & reverse function.
Use bubble sort algorithm to rearrange the array in decreasing order.
Iterate through the array and compare adjacent elements, swapping them if they are in the wrong order.
Repeat this process until the array is sorted in decreasing order.
Example: ['apple', 'banana', 'cherry'] -> ['cherry', 'banana', 'apple']
Q10. What is encapsulation, TDP, UDP, Normalization etc
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit.
Encapsulation helps in hiding the internal state of an object and restricting access to it.
It allows for better control over the data by preventing direct access from outside the class.
Example: In object-oriented programming, classes are used to implement encapsulation by combining data attributes and methods.
TDP stands for Transmission Control Protocol, a connection-oriented...read more
Q11. What are the recent technologies you worked with?
I have worked with React, Node.js, and AWS recently.
Developed a web application using React and Node.js
Deployed the application on AWS EC2 instance
Used AWS S3 for storing and retrieving files
Implemented authentication and authorization using AWS Cognito
Integrated Stripe payment gateway for online payments
Q12. What are constraints in Sql
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 creating a table or altered later using the ALTER TABLE stateme...read more
Q13. Selection sort algorithm
Selection sort is a simple sorting algorithm that repeatedly selects the smallest element from an unsorted list.
It has a time complexity of O(n^2)
It is an in-place comparison-based algorithm
It is not suitable for large datasets
Example: [64, 25, 12, 22, 11] -> [11, 12, 22, 25, 64]
Q14. How to do ETL Design
ETL design involves identifying data sources, defining data transformations, and selecting a target system for loading the transformed data.
Identify data sources and determine the data to be extracted
Define data transformations to convert the extracted data into the desired format
Select a target system for loading the transformed data
Consider scalability, performance, and data quality issues
Use ETL tools such as Informatica, Talend, or SSIS to automate the process
Test and val...read more
Q15. reverse a string
Reverse a string by iterating through the characters and swapping them
Create a function that takes a string as input
Initialize two pointers, one at the beginning and one at the end of the string
Swap the characters at the two pointers and move them towards the center until they meet
Q16. Sort linked list
Sort a linked list
Use a sorting algorithm like merge sort or quick sort
Traverse the linked list and rearrange the nodes accordingly
Ensure to update the head of the linked list after sorting
More about working at Optum
Top HR Questions asked in BEO Software
Interview Process at BEO Software
Top Software Engineer Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month