Faster and better experience!
Filter interviews by
Typical DSA questions
I applied via Company Website and was interviewed in May 2022. There was 1 interview round.
I applied via Naukri.com
I was interviewed before Mar 2021.
Round duration - 60 Minutes
Round difficulty - Easy
In this round, I was first asked a simple coding question related to Recursion and then the interviewer switched the topic of discussion towards Java and OOPS and towards the end of the interview I was also asked some questions revolving around DB2 and DBMS.
Determine if a given string 'S' is a palindrome, considering only alphanumeric characters and ignoring spaces and symbols.
The string 'S' should be evaluated in a case...
Code :
import java.util.*;
public class Test {
public static void main(String args[]) {
Scanner s = new Scanner(System.in);
String word = s.nextLine();
System.out.println("Is "+word+" palindrome? - "+isWordPalindrome(word));
}
public static boolean isWordPalindrome(String word){
String reverseWord = getReverseWord(word);
//if word equals its reverse, then it is a palindrome
if(word.equals(rever...
1) Class(Method) Area: Class Area stores per-class structures such as the runtime constant pool, field, method data,
and the code for methods.
2) Heap: It is the runtime data area in which the memory is allocated to the objects
3) Stack: Java Stack stores frames. It holds local variables and partial results, and plays a part in method invocation
and return. Each thread has a private JVM stack, created at the same time as t...
The best way of putting a CURSOR to use in a COBOL program is to make use of DECLARE CURSOR, which can be used either in procedure division operation or in working storage. This is being done basically to highlight the SELECT statement. Once DECLARE CURSOR is used, this is followed by OPEN, FETCH and finally CLOSE.
To find number of rows : The user has to use SELECT COUNT (*) on the DB2 query.
To eliminate duplicate values from DB2 SELECT : The user has to use SELECT DISTINCT in the DB2 query.
Normalization is a process of reducing redundancy by organizing the data into multiple tables. Normalization leads to
better usage of disk spaces and makes it easier to maintain the integrity of the database.
Denormalization is the reverse process of normalization as it combines the tables which have been normalized into a
single table so that data retrieval becomes faster. JOIN operation allows us to create a denormalize...
A Subquery is also known as a nested query i.e. a query written inside some query. When a Subquery is executed for each of the rows of the outer query then it is termed as a Correlated Subquery.
Example of Non-Correlated Subquery is :
SELECT * from EMP WHERE ‘JOHN’ IN (SELECT Name from DEPT WHERE EMP.EMPID=DEPT.EMPID);
Round duration - 50 Minutes
Round difficulty - Medium
This round had questions primarily from Spring Boot and Java. The interviewer was quite friendly and helped me with small hints when he felt I was stuck. Overall, this round went preety well.
RequestMapping can be used with GET, POST, PUT, and many other request methods using the method attribute on
the annotation. Whereas GetMapping is only an extension of RequestMapping, which helps you to improve clarity on
requests.
Spring Boot automatically configures your application based on the dependencies you have added to the project by
using annotation. The entry point of the spring boot application is the class that contains @SpringBootApplication
annotation and the main method.
Spring Boot automatically scans all the components included in the project by using @ComponentScan annotation.
Here is how MVC works in Spring :
1) DispatcherServlet receives a request.
2) After that, the DispatcherServlet communicates with HandlerMapping. It also revokes the controller associated with
that specific request.
3) The Controller processes this request by calling the service methods, and a ModelAndView object is returned by
the DispatcherServlet.
4) The view name is sent to a ViewResolver to find the actual View to invok...
Few important features of Spring Boot are as follows:
1) Spring CLI – Spring Boot CLI allows you to Groovy for writing Spring boot application and avoids boilerplate code.
2) Starter Dependency – With the help of this feature, Spring Boot aggregates common dependencies together and eventually improves productivity
3) Auto-Configuration – The auto-configuration feature of Spring Boot helps in loading the default configurat...
Below are the two significant features of the methods that are defined as the lambda expressions:
1) Lambda expressions can be passed as a parameter to another method.
2) Lambda expressions can be standalone without belonging to any class.
Some of the famous pre-defined functional interfaces from previous Java versions are Runnable, Callable,
Comparator, and Comparable. While Java 8 introduces functional interfaces like Supplier, Consumer, Predicate, etc.
Please refer to the java.util.function doc for other predefined functional interfaces and its description introduced in
Java 8.
Runnable: use to execute the instances of a class over another thread with no ...
The differences between Abstract Class and Interface are as follows :
Abstract Class:
1) Abstract classes have a default constructor and it is called whenever the concrete subclass is instantiated.
2) It contains Abstract methods as well as Non-Abstract methods.
3) The class which extends the Abstract class shouldn’t require the implementation of all the methods, only Abstract
methods need to be implemented in the concrete ...
The super keyword is used to access hidden fields and overridden methods or attributes of the parent class.
Following are the cases when this keyword can be used :
1) Accessing data members of parent class when the member names of the class and its child subclasses are same.
2) To call the default and parameterized constructor of the parent class inside the child class.
3) Accessing the parent class methods when the
Round duration - 30 Minutes
Round difficulty - Easy
This was a Technical Cum HR round where I was first asked some basic Java related concepts and then we discussed
about my expectations from the company , learnings and growth in the forthcomig years. I would suggest be honest and
try to communicate your thoughts properly in these type of rounds to maximise your chances of getting selected.
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 3 : Do at-least 2 good projects and you must know every bit of them.
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.
Capita interview questions for designations
I was interviewed in Dec 2018.
Sorting using JCL and COBOL
JCL can be used to submit a COBOL program for sorting
COBOL program can use SORT verb to sort data
Sorting can be done based on specific fields or criteria
COBOL program can use SORT-RETURN to check the status of the sort operation
Cursor is a database object used to manipulate data in a result set.
Cursor is used to fetch a set of rows from a result set.
It allows the application to move forward and backward through the result set.
Cursor can be declared and opened in SQL.
It can be used to update or delete rows in a result set.
Cursor can be closed explicitly or implicitly.
Use SQL query with WHERE clause to filter out low values while fetching data from DB2 table
Use SELECT statement to fetch data from table
Add WHERE clause with condition to filter out low values
Example: SELECT * FROM table_name WHERE column_name > 10
Use ORDER BY clause to sort the data in ascending or descending order
Display values from a table with alternate value
Use a loop to iterate through the table values
Use an if-else statement to check for alternate values
Display the alternate values using a different formatting or color
Consider using CSS or JavaScript to enhance the display
Get interview-ready with Top Capita Interview Questions
I was interviewed before Apr 2021.
Round duration - 60 Minutes
Round difficulty - Medium
In this round, I was first asked a simple coding question related to stack and recursion followed by an SQL query. After this, I was grilled on some fundamental concepts of Java, OOPS and Java 8.
Reverse a given stack of integers using recursion. You must accomplish this without utilizing extra space beyond the internal stack space used by recursion. Additionally, you ...
Approach : We will be using two recursive methods -
1) ReverseStack(stack)
i) If the stack is empty, then return
ii) Pop the top element from the stack as top
iii) Reverse the remaining elements in the stack, call reverseStack(stack) method
iv) Insert the top element to the bottom of the stack, call InsertAtBottom(stack, top) method
2) InsertAtBottom(stack, ele)
i) If the stack is empty, push ele to stack, return
ii) Pop the t...
Approach : Since the PersonId in table Address is the foreign key of table Person, we can join this two table to get the
address information of a person. Considering there might not be an address information for every person, we should
use outer join instead of the default inner join.
Query :
select FirstName, LastName, City, State
from Person left join Address
on Person.PersonId = Address.PersonId ;
1) Class(Method) Area: Class Area stores per-class structures such as the runtime constant pool, field, method data,
and the code for methods.
2) Heap: It is the runtime data area in which the memory is allocated to the objects
3) Stack: Java Stack stores frames. It holds local variables and partial results, and plays a part in method invocation
and return. Each thread has a private JVM stack, created at the same time as t...
Comparator, and Comparable. While Java 8 introduces functional interfaces like Supplier, Consumer, Predicate, etc.
Please refer to the java.util.function doc for other predefined functional interfaces and its description introduced in
Java 8.
Runnable: use to execute the instances of a class over another thread with no arguments and no return value.
Callable: use to execute the instances of a class over another thread with...
Below are the two significant features of the methods that are defined as the lambda expressions:
1) Lambda expressions can be passed as a parameter to another method.
2) Lambda expressions can be standalone without belonging to any class.
It encapsulates optional values, i.e., null or not-null values, which helps in avoiding null checks, which results in
better, readable, and robust code. It acts as a wrapper around the object and returns an object instead of a value,
which can be used to avoid run-time NullPointerExceptions.
Round duration - 60 Minutes
Round difficulty - Medium
This round was majorly inclined towards Spring Boot and Hibernate and the questions can be answered only if you have some prior experience in working with these tech stacks.
1) Spring Actuator is a cool feature of Spring Boot with the help of which you can see what is happening inside a running application.
2) So, whenever you want to debug your application, and need to analyze the logs you need to understand what is happening in the application.
3) In such a scenario, the Spring Actuator provides easy access to features such as identifying beans, CPU usage, etc.
4) The Spring Act...
The @Transactional annotation is the metadata that specifies the semantics of the transactions on a method. We have two ways to rollback a transaction: declarative and programmatic.
In the declarative approach, we annotate the methods with the @Transactional annotation. The @Transactional annotation makes use of the attributes rollbackFor or rollbackForClassName to rollback the transactions, and the attributes noRollbac...
1) Spring Boot Batch provides reusable functions that are essential in processing large volumes of records, including logging/tracing, transaction management, job processing statistics, job restart, skip, and resource management.
2) It also provides more advanced technical services and features that will enable extremely high-volume and high performance batch jobs though optimization and partitioning techniques.
3)...
@RequestMapping :
1) This annotation is used to provide the routing information and tells to Spring that any HTTP request must be mapped to the respective method.
2) To use this annotation, you have to import org.springframework.web.
"bind.annotation.RequestMapping;"
@RestController :
1) This annotation is used to add the @ResponseBody and @Controller annotation to the class
2) To use this annotation, you have to...
setMaxResults() the function works similar to LIMIT in SQL. Here, we set the maximum number of rows that we want
to be returned. This method is implemented by all database drivers.
setFetchSize() works for optimizing how Hibernate sends the result to the caller for example: are the results buffered,
are they sent in different size chunks, etc. This method is not implemented by all the database drivers.
Concurrency strategies are the mediators responsible for storing and retrieving items from the cache. While enabling
second-level cache, it is the responsibility of the developer to provide what strategy is to be implemented to decide for
each persistent class and collection.
Following are the concurrency strategies that are used:
1) Transactional: This is used in cases of updating data that most likely causes stale data a...
Session interface is primarily used by hibernate application. Session is light weight,short lived objects which are
inexpensive to create and destroy. It allows you to create query objects to retrieve persistent objects.It wraps JDBC
connection Factory for Transaction.It holds a mandatory (first-level) cache of persistent objects, used when navigating
the object graph or looking up objects by identifier .
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 : The cross questioning can go intense some time, think before you speak.
Tip 2 : Be open minded and answer whatever you are thinking, in these rounds I feel it is important to have opinion.
Tip 3 : Context of questions can be switched, pay attention to the details. It is okay to ask questions in these round,
like what are the projects currently the company is investing, which team you are mentoring. How all is the ...
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 3 : Do at-least 2 good projects and you must know every bit of them.
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 in Oct 2017. There were 4 interview rounds.
Yes
Implemented OOPs concepts in the project using Stream API
Utilized Map in Collections to implement OOPs principles
Used Stream API to apply functional programming concepts in the project
The @Transactional annotation is used in Spring JPA to manage transactions in database operations.
The @Transactional annotation is used to mark a method or class as transactional.
It ensures that all database operations within the annotated method or class are executed within a single transaction.
If an exception occurs, the transaction is rolled back, and changes made within the transaction are not persisted.
The @Transa...
A controller to handle POST requests in a Spring REST API.
Create a new class annotated with @RestController
Define a method in the class annotated with @PostMapping
Use @RequestBody annotation to bind the request body to a parameter
Implement the logic to handle the POST request
Return the response using ResponseEntity
Annotations used in web services, pagination, exception handling in Spring
Web services in Spring can be annotated with @RestController or @Controller
Pagination can be achieved using @PageableDefault and @PageableParam
Exception handling can be done using @ExceptionHandler and @ControllerAdvice
Top trending discussions
I applied via campus placement at J S S Academy of Technical Education, Bangalore and was interviewed in Dec 2024. There were 3 interview rounds.
Average to easy difficulty level.
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
Some of the top questions asked at the Capita Software Consultant interview -
based on 1 interview
3 Interview rounds
based on 53 reviews
Rating in categories
Senior Executive
1.2k
salaries
| ₹1.5 L/yr - ₹6.1 L/yr |
Senior Software Consultant
553
salaries
| ₹8.8 L/yr - ₹26 L/yr |
Softwaretest Engineer
543
salaries
| ₹3 L/yr - ₹8.5 L/yr |
Customer Service Executive
414
salaries
| ₹1.5 L/yr - ₹6.7 L/yr |
Software Consultant
390
salaries
| ₹4.5 L/yr - ₹15.2 L/yr |
Wipro
TCS
Infosys
HCLTech