Capita DOT NET Developer Interview Questions and Answers

Good,SQL query and c# programs

Q1. Oops related questions
Add your answer
Q2. Design pattern related questions
Add your answer

Q1. Interviewer was rude
Add your answer
Q2. Oops c# basics sql azure
Add your answer

Q1. What is work of team lead? how do you handle workload of yours and the junior assigned to you? how do u handle conflicts?
Ans. 
Team lead is responsible for managing the workload of the team, including assigning tasks, providing guidance, and resolving conflicts.
• Assign tasks to team members based on their skills and workload capacity

• Provide guidance and support to junior team members to help them complete their tasks successfully

• Monitor progress of tasks and ensure deadlines are met

• Resolve conflicts within the team by listening to all parties i...read more
Answered by AI
Add your answer
Q2. Other deep technical questions
Add your answer

Q1. Dependency injection
Add your answer

Q1. Ticketing system design
Ans. 
Ticketing system design involves creating a platform for users to submit, track, and resolve issues or requests.
• Design a user-friendly interface for submitting tickets

• Implement a system for assigning tickets to appropriate teams or individuals

• Include features for tracking ticket status and communication with users

• Consider scalability and performance of the system

• Integrate with other tools or systems for seamless workfl
Answered by AI
Add your answer
Q2. Aws ec2 and jenkins
Add your answer

Q1. Asp.net, C#, Coding questions
Add your answer

Q1. Salary discussion
Add your answer

Q1. Basic questions as mcqs
Add your answer

Q1. What is .net,what is oops explain briefly
Ans. 
The .NET framework is a software development platform developed by Microsoft. OOPs stands for Object-Oriented Programming, a programming paradigm based on the concept of objects.
• The .NET framework is used for building various types of applications, including web, desktop, and mobile applications.

• OOPs is a programming paradigm that uses objects and classes to design and develop applications.

• In OOPs, objects are instance...read more
Answered by AI
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

2 Programing Questions and 30 MCQs. 
Programing questions were medium with one being array manipulation and other being graph based. 

MCQ were from OOPs concepts, SQL, Operating System and Network, prepare in depth knowledge for all the topics.

Q1. 
Count Pairs Problem Statement
You are given an array A of length N consisting only of integers. Additionally, you are provided with three integers X, Y and SUM. Your task is to count the number of pairs (...read more
Ans. 
Using HashMap or self balancing BST for fastest result.
Answered Anonymously
Add your answer
Q2. 
Longest Substring Without Repeating Characters Problem Statement
Given a string S of length L, determine the length of the longest substring that contains no repeating characters.
Example:
Input:
"abac...read more
Ans. Brute Force
In the brute force approach, we will use two nested loops. The outer loop is used to select the starting index of the substring and the inner loop is used to fix the ending index of the substring. After selecting the substring, we will use another loop (or a method) to check whether the substring contains all unique characters or not using a HashSet.
Space Complexity: O(n)Explanation:
O(L), where L is the len...read more
Answered Anonymously
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Questions on SQL and DBMS were asked in this round

Q1. What are the ACID properties in DBMS?
View 1 more answer
Q2. Can you explain the different levels of data abstraction in a DBMS?
Add your answer
Q3. What are constraints in SQL?
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

HR round was pretty much a casual conversation about why optum, work location, joining availablity and what qualities you would like to highlight about yourself.

Q1. Why do you want to work at Optum, and what qualities would you like to highlight?
Ans. 
Tip 1 : Go through wiki page or google about the working of the company
Tip 2 : Qualities should more aligned to the company's values.
Tip 3 : Show your interest in working with the organisation and how will you contribute to the team.
Answered Anonymously
Add your answer

Q1. SQL Query Performance tuning
Add your answer