Aetna Interview Questions and Answers

Stack using queues: push() - enqueue to queue1, pop() - dequeue from queue2 after transferring n-1 elements from queue1 to queue2

• To push an element, enqueue it to queue1

• To pop an element, transfer n-1 elements from queue1 to queue2, dequeue the last element from queue1 and swap the names of queue1 and queue2

• Queue using stacks: enqueue() - push to stack1, dequeue() - pop from stack2 after transferring all elements from ...read more

Doubly linked list is a data structure where each node has a pointer to both previous and next nodes.

• Create a Node class with data, prev and next pointers

• Create a LinkedList class with head and tail pointers

• Implement methods to add, remove and traverse nodes

Yes, I am a leader.

• I have experience leading teams in previous projects.

• I am able to communicate effectively and motivate team members.

• I am proactive in identifying and solving problems.

• I am able to delegate tasks and trust team members to complete them.

• I am constantly seeking to improve my leadership skills through learning and feedback.

I am a recent computer science graduate with experience in software development and a passion for learning new technologies.

• Graduated with a degree in computer science

• Experience in software development

• Passionate about learning new technologies

The company is a software development firm.

• The company specializes in software development.

• It has a team of experienced software engineers.

• The company has worked on various projects for clients in different industries.

• It is known for delivering high-quality software solutions.

• The company values innovation and creativity in its work.

Formula to calculate number of squares that can fit inside a triangle

• Calculate the area of the triangle and the area of the square

• Divide the area of the triangle by the area of the square to get the number of squares that can fit inside the triangle

• Formula: (h*b)/(a*a)

SVM is a machine learning algorithm used for classification and regression analysis.

• SVM finds the best hyperplane that separates data into different classes.

• It works by maximizing the margin between the hyperplane and the closest data points.

• SVM can handle both linear and non-linear data using kernel functions.

• It is widely used in image classification, text classification, and bioinformatics.

• SVM has been shown to be ef...read more

Logistic regression is used for classification while linear regression is used for regression analysis.

• Logistic regression predicts the probability of an event occurring, while linear regression predicts the value of a continuous variable.

• Logistic regression uses a sigmoid function to map input values to a probability between 0 and 1.

• Linear regression assumes a linear relationship between the independent and dependent ...read more

Eligible customers for Vodafone's 4G service launch in India.

• Customers with 4G compatible devices

• Customers with high data usage

• Customers in areas with good network coverage

• Customers who have shown interest in technology and gadgets

• Customers who have previously used Vodafone's high-speed data services

• Customers who have opted-in to receive promotional messages

I am a detail-oriented Business Analyst with strong analytical skills. My strengths include problem-solving and communication, while my weakness is sometimes being too detail-oriented.

• Strengths: strong analytical skills

• Strengths: problem-solving abilities

• Strengths: effective communication skills

• Weakness: being too detail-oriented

• Weakness: sometimes struggle with delegation

Yes, I am willing to work extra hours and weekends when necessary.

• I am committed to meeting project deadlines and delivering high-quality work.

• I understand that sometimes extra hours may be required to complete tasks or address urgent issues.

• I have previous experience working weekends and extra hours when needed, such as during busy project phases or critical system upgrades.

Yes, I am okay with working in Noida.

• I am open to working in Noida and have no issues with the location.

• I have worked in Noida before and am familiar with the area.

• I am willing to relocate to Noida if required for the job.

Find the heavier ball out of 8 using a weighing balance in minimum and maximum attempts.

• Divide the balls into 3 groups of 3, 3, and 2.

• Weigh the first two groups against each other.

• If they balance, the heavier ball is in the third group.

• If one group is heavier, weigh two balls from that group against each other.

• If they balance, the heavier ball is the remaining one.

• If one ball is heavier, that is the answer.

• In the worst...read more

In 3 attempts, the heavier ball can be found using the weighing balance.

• Divide the balls into 3 groups of 3, 3, and 5 balls.

• Weigh the first two groups against each other.

• If they balance, the heavier ball is in the third group. Weigh two balls from the third group against each other to find the heavier one.

• If they don't balance, the heavier ball is in the heavier group. Take two balls from the heavier group and weigh th

Use a binary search approach to find the heavier ball among 'n' balls using a weighing balance.

• Divide the 'n' balls into two equal groups and weigh them on the balance.

• If one group is heavier, repeat the process with that group.

• If both groups weigh the same, the heavier ball is among the remaining unweighed balls.

• Continue dividing and weighing until the heavier ball is found.

The number of soft drinks sold in J&K on a particular day depends on various factors such as population, demand, availability, and marketing strategies.

• The population of J&K can be a factor in determining the potential number of soft drink sales.

• The demand for soft drinks can vary based on factors such as weather, events, and cultural preferences.

• The availability of soft drinks in J&K, including distribution channels a...read more

Estimating the market size of 4K and 8K display screens.

• Analyze sales data and market research reports

• Consider the adoption rate of 4K and 8K technology

• Evaluate the market demand from various industries (entertainment, gaming, advertising, etc.)

• Assess the pricing and availability of 4K and 8K displays

• Factor in the growth potential and competition in the market

Area of square except inscribed circle

• Find area of square

• Subtract area of circle from square

• Area of square = L^2, Area of circle = pi*(L/2)^2

• Answer = L^2 - pi*(L/2)^2

A program to find factorial using recursion.

• Define a function that takes an integer as input.

• Check if the input is 0 or 1, return 1 in that case.

• Otherwise, call the function recursively with input-1 and multiply it with the input.

Indexes are data structures that improve the speed of data retrieval operations in a database. Views are virtual tables created from queries.

• Indexes are used to quickly locate data in a database by creating a sorted structure that allows for efficient searching.

• Views are virtual tables that are created by executing a query and storing the result set as a named object.

• Indexes can be created on one or more columns of a t...read more

Indexes are implemented using B Trees and B+ Trees.

• B Trees and B+ Trees are data structures used to organize and efficiently search data in databases.

• B Trees are balanced search trees that store data in nodes with multiple children.

• B+ Trees are similar to B Trees but have additional features like leaf nodes that form a linked list.

• Indexes are created on specific columns of a database table to improve query performance.

• ...read more

Other than indexes and tables, a DBMS also includes views, stored procedures, triggers, and functions.

• Views: Virtual tables that are based on the result of a query. They provide a way to simplify complex queries and restrict access to data.

• Stored Procedures: Precompiled sets of SQL statements that can be executed with a single command. They enhance performance and allow for code reusability.

• Triggers: Special types of s...read more

A database administrator manages and maintains databases, ensuring their security, performance, and availability.

• Designing and implementing database structures

• Installing and configuring database software

• Monitoring and optimizing database performance

• Ensuring data integrity and security

• Backing up and restoring databases

• Troubleshooting and resolving database issues

• Collaborating with developers and system administrators

• Pla...read more

Types of integrity in DBMS include foreign, referential, and domain.

• Foreign integrity ensures that foreign key values in a table match primary key values in another table.

• Referential integrity ensures that relationships between tables are maintained, preventing orphaned or invalid data.

• Domain integrity ensures that data in a column adheres to specified data types, formats, or constraints.

• For example, in a database for ...read more

SDLC is a process followed by software development teams to design, develop and test high-quality software.

• SDLC stands for Software Development Life Cycle

• It consists of several phases including planning, analysis, design, implementation, testing, and maintenance

• Each phase has its own set of activities and deliverables

• The goal of SDLC is to produce high-quality software that meets customer requirements and is delivered ...read more

Agile methodology is an iterative and incremental approach to software development.

• Agile methodology emphasizes collaboration, flexibility, and customer satisfaction.

• It involves breaking down the project into small, manageable tasks called user stories.

• Teams work in short iterations called sprints, typically 1-4 weeks long.

• Regular meetings like daily stand-ups and sprint reviews are held to track progress and gather fe...read more

In 3-5 years, I see myself as a senior software engineer leading a team of developers on innovative projects.

• Advancing to a senior software engineer role

• Leading a team of developers on projects

• Working on innovative and challenging projects

• Continuing to learn and grow in the field

I am a passionate software engineer with experience in developing web applications using various technologies.

• Experienced in full-stack web development

• Proficient in languages such as JavaScript, Python, and Java

• Familiar with frameworks like React, Node.js, and Django

• Strong problem-solving skills and ability to work in a team

• Completed projects like e-commerce website using MERN stack

I want to learn how to play the piano.

• I have always been fascinated by music and the piano in particular.

• Learning to play an instrument can be a great way to relax and unwind.

• Playing the piano can also improve cognitive skills and memory.

• I believe learning to play the piano will bring me joy and fulfillment.

My strengths include problem-solving skills and attention to detail. My weaknesses include public speaking and time management.

• Strengths: problem-solving skills, attention to detail

• Weaknesses: public speaking, time management

Activity flow diagrams for Ola cabs management system and washing machine.

• Ola cabs management system: User books a cab -> Driver accepts the ride -> User gets picked up -> User reaches destination -> Payment is made.

• Washing machine: User selects wash cycle -> Machine fills with water -> Detergent is added -> Machine agitates clothes -> Water drains -> Clothes are rinsed -> Machine spins clothes -> Cycle ends.