Filter interviews by
I was interviewed before Apr 2021.
Round duration - 60 Minutes
Round difficulty - Medium
In this round, the interviewer asked me 2 coding questions , the first one was related to Simple Hashing and the second one was to implement Kadane's Algorithm. I coded both the solutions in the given time and at the end was also asked some questions revolving around OOPS and C#.
Given an array of integers ARR
of length N
and an integer Target
, your task is to return all pairs of elements such that they add up to the Target
.
The first line ...
Approach :
1) We can store the frequency of every element in the array in a hashmap.
2) We will loop over every index i, and check the frequency of (Target - ARR[i]) is the hashmap :
2.1) If (Target - ARR[i]) is equal to ARR[i], we will check if frequency of ARR[i] . If it is greater than 1 then we will
decrease the frequency of ARR[i] by 2 and add a pair (ARR[i] , ARR[i]) to our answer.
2.2) Else, if the frequency of...
Given an array or list ARR
consisting of N
integers, your objective is to compute the maximum possible sum obtainable from a non-empty subarray (a contiguous sequence) within thi...
Approach (Using Kadane's Algo) :
1) Declare a variable ‘maxSum’ and initialize it with ‘minimum integer’.
2) Declare a variable ‘localSum’ and initialize it with ‘0’.
3) Declare 3 counter variables as ‘start’ , ‘end’ , ‘newStart’ as 0, 0, 0.
4) Run a loop from i = 0 to N
4.1) Add a current element to ‘localSum’.
4.2) If 'localSum' is greater than 'maxSum'
Update ‘maxSum’ with 'localSum', update start with ‘newStart’ and end w...
1) Data Encapsulation is an Object-Oriented Programming concept of hiding the data attributes and their behaviors in
a single unit.
2) It helps developers to follow modularity while developing software by ensuring that each object is independent of
other objects by having its own methods, attributes, and functionalities.
3) It is used for the security of the private properties of an object and hence serves the purpose of d
Overloading means when a method has the same name but carries different values to use in a different context. Only the main() method cannot be overloaded.
In order to overload methods in C#,
1) Change the number of parameters in a method, or
2) Change the order of parameters in a method, or
3) Use different data types for parameters
In these ways, you can overload a method multiple times.
EXAMPLE :
public class Ar...
Round duration - 60 Minutes
Round difficulty - Medium
This round was preety much mixed and had questions from LINQ , .NET framework, DBMS, OOPS and Design Patterns.
LINQ : The word LINQ is the abbreviation of the Language Integrated Query. It's a .NET framework module that connects native data querying capabilities to .net Language. It offers easy data access from in-memory objects, databases, XML documents, and many more.
The advantages of LINQ are as follows -
1) The primary purpose of using LINQ is to retrieve complex query in a dataset.
2) LINQ is used to combine the values from ...
Some significant differences between LINQ and Stored Procedure are as follows -
1) The stored procedure is faster than a LINQ query because they follow a proper (Expected) execution plan.
2) It is easy to avoid run time errors in SQL query than in comparison to a stored procedure.
3) LINQ uses the .NET debugger to allow debugging, which is not in case of stored procedures.
4) LINQ supports multiple databases in contrast to...
Lambda expressions are extensively used in Expression Tree construction. An Expression Tree represents code in a tree-like format, where each node acts as an impression. Expression trees can be converted into compiled code and run it.
In, .NET framework, Expression class is used to create expression tree through the API. Expression Trees API also support assignment and some control flow expression such as conditional bl...
Triggers :
1) A Trigger is implicitly invoked whenever any event such as INSERT, DELETE, UPDATE occurs in a TABLE.
2) Only nesting of triggers can be achieved in a table. We cannot define/call a trigger inside another trigger.
3) In a database, syntax to define a trigger: CREATE TRIGGER TRIGGER_NAME.
4) Transaction statements such as COMMIT, ROLLBACK, SAVEPOINT are not allowed in triggers.
5) Triggers are used to main...
Abstraction :
1) If you are a user, and you have a problem statement, you don't want to know how the components of the software work, or how it's made. You only want to know how the software solves your problem.
2) Abstraction is the method of hiding unnecessary details from the necessary ones. It is one of the main features of OOPs.
3) For example, consider a car. You only need to know how to run a car,...
There are three types of design patterns. They are :
1) Creational Patterns: These patterns provide freedom of choice between creating objects by hiding the logic. The
objects constructed are decoupled from the implemented system. Some of the examples of creational patterns are -
Factory design pattern, Builder design, Prototype design, Singleton design, Abstract Factory design.
2) Structural Patterns: These patterns...
Round duration - 30 Minutes
Round difficulty - Easy
This is a cultural fitment testing round. HR was very frank and asked standard questions. Then we discussed about my
role.
If you get this question, it's an opportunity to choose the most compelling information to share that is not obvious from
your resume.
Example :
Strength -> I believe that my greatest strength is the ability to solve problems quickly and efficiently, which makes me
unique from others.
Ability to handle Pressure -> I enjoy working under pressure because I believe it helps me grow and become more
efficient.
Tip : Emphasiz...
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via Naukri.com and was interviewed before Nov 2019. There was 1 interview round.
LINQ (Language Integrated Query) is a Microsoft technology that allows querying data from different sources using a common syntax.
LINQ provides a unified way to query data from different sources such as databases, XML documents, and collections.
It allows developers to write queries using a common syntax regardless of the data source.
LINQ queries are strongly typed and can be checked at compile time.
Examples of LINQ pro...
ADO.NET is a data access technology used to connect applications to databases.
ADO.NET provides a set of classes to interact with databases.
It supports disconnected data architecture.
It uses Data Providers to connect to different databases.
It supports LINQ to SQL for querying databases.
Examples of Data Providers are SQL Server, Oracle, MySQL, etc.
WPF stands for Windows Presentation Foundation. It is a graphical subsystem for rendering user interfaces in Windows-based applications.
WPF is a part of .NET Framework and provides a unified programming model for building desktop applications.
It uses XAML (eXtensible Application Markup Language) to define and create user interfaces.
WPF supports rich media, 2D and 3D graphics, animation, and data binding.
It allows for s...
WPF provides better UI design and development options than Windows Forms.
WPF allows for more flexible and customizable UI design.
WPF supports vector graphics and animations.
WPF has better data binding capabilities.
WPF is more modern and actively developed than Windows Forms.
WPF is better suited for creating modern desktop applications.
Procedures and triggers are database objects used to automate tasks and enforce rules.
Procedures are a set of SQL statements that can be executed repeatedly.
Triggers are special types of procedures that are automatically executed in response to certain events.
Triggers can be used to enforce business rules, audit changes, or replicate data.
Procedures and triggers can be written in various programming languages such as S
An abstract class is a class that cannot be instantiated and is used as a base class for other classes.
An abstract class can have abstract and non-abstract methods.
Abstract methods have no implementation and must be implemented by the derived class.
An abstract class can have constructors and fields.
An abstract class can be used to define a common interface for a group of related classes.
Example: Animal is an abstract c
Encapsulation is hiding implementation details while abstraction is showing only necessary details.
Encapsulation is achieved through access modifiers like private, protected, and public.
Abstraction is achieved through abstract classes and interfaces.
Encapsulation provides data security and prevents unauthorized access.
Abstraction helps in reducing complexity and improves maintainability.
Example of encapsulation: Class ...
Singleton design pattern restricts the instantiation of a class to a single instance.
Ensures only one instance of a class exists
Provides a global point of access to that instance
Used when only one object is needed to coordinate actions across the system
Example: Database connection manager
I applied via Naukri.com and was interviewed before May 2021. There was 1 interview round.
MVC life cycle is a series of steps that occur when a request is made to an MVC application.
Request is received by the routing engine
Routing engine determines the controller and action to handle the request
Controller is instantiated and action method is called
Action method returns a view
View is rendered and returned as a response
What people are saying about Capita
Dependency Injection is a design pattern in which components are given their dependencies rather than creating them internally.
Allows for easier testing by providing mock dependencies
Promotes loose coupling between components
Improves code reusability and maintainability
Examples: Constructor injection, Setter injection, Interface injection
In Java, exceptions can be handled using try-catch blocks to catch and handle specific exceptions.
Use try-catch blocks to catch exceptions and handle them gracefully
Use multiple catch blocks to handle different types of exceptions
Use finally block to execute code regardless of whether an exception is thrown or not
Throw custom exceptions using throw keyword
map transforms each element in a stream, while flatMap transforms each element into multiple elements
map applies a function to each element in a stream and returns a new stream of the results
flatMap applies a function that returns a stream for each element in the original stream, then flattens the streams into a single stream
Example: map - stream.map(x -> x * x), flatMap - stream.flatMap(str -> Arrays.stream(str.split(
ConcurrentModificationException occurs when a collection is modified while iterating over it.
Use Iterator to iterate over the collection instead of foreach loop.
If modification is necessary, use Iterator's remove() method instead of collection's remove() method.
Consider using synchronized collections or ConcurrentHashMap to avoid ConcurrentModificationException.
Coding and aptitude coding and aptitude with technical questions
Object-oriented programming concepts that focus on classes and objects
Encapsulation: Bundling data and methods that operate on the data into a single unit (class)
Inheritance: Ability of a class to inherit properties and behavior from another class
Polymorphism: Ability to present the same interface for different data types
Abstraction: Hiding the complex implementation details and showing only the necessary features
Developed a web-based project management tool for tracking tasks and deadlines.
Used HTML, CSS, and JavaScript for front-end development
Utilized Node.js and MongoDB for back-end development
Implemented user authentication and authorization features
posted on 4 Dec 2024
It was an online assessment containing 3 DSA questions
I applied via Recruitment Consulltant
posted on 24 Aug 2024
Domain is the area of expertise or knowledge, data elements are individual pieces of data, and database tables are structures to store data.
Domain refers to a specific area of expertise or knowledge, such as healthcare, finance, or education.
Data elements are individual pieces of data that make up a larger dataset, such as name, age, address, etc.
To create a database table, you need to define the table's structure incl...
Various technologies used in the project include Java, Spring Boot, Angular, MySQL, and Docker.
Java
Spring Boot
Angular
MySQL
Docker
based on 18 reviews
Rating in categories
Senior Executive
1.2k
salaries
| ₹1.5 L/yr - ₹6.3 L/yr |
Softwaretest Engineer
598
salaries
| ₹2.5 L/yr - ₹8.5 L/yr |
Senior Software Consultant
553
salaries
| ₹8.8 L/yr - ₹26 L/yr |
Customer Service Executive
414
salaries
| ₹1.5 L/yr - ₹6.7 L/yr |
Software Consultant
395
salaries
| ₹3.7 L/yr - ₹15 L/yr |
Wipro
TCS
Infosys
HCLTech