Add office photos
Filter interviews by
Capita Software Consultant Interview Questions, Process, and Tips
Top Capita Software Consultant Interview Questions and Answers
- Q1. Check If The String Is A Palindrome You are given a string 'S'. Your task is to check whether the string is palindrome or not. For checking palindrome, consider alphabets ...read more
- Q2. Reverse Stack Using Recursion Reverse a given stack of integers using recursion. Note: You are not allowed to use any extra space other than the internal stack space used ...read more
- Q3. Spring Boot Question What are the @RequestMapping and @RestController annotation in Spring Boot used for?
Capita Software Consultant Interview Experiences
7 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Oct 2017. There were 4 interview rounds.
Interview Questionnaire
6 Questions
- Q1. Where did u implemented oops concepts in your project? Stream api, Map in Collections
- Ans.
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
- Q2. Usage of @Transactional annotation in spring JPA
- Ans.
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...
- Q3. Write controller to serve POST request for a rest call in spring
- Ans.
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
- Q4. Again technical discussion focused on Spring MVC, spring Boot annotations, hibernate mapping, caching, restfull webservices
- Q5. Annotations used in web services, pagination, exception handling in spring
- Ans.
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
- Q6. Salary discussion. They will explain about policies, about project etc
Interview Preparation Tips
Pros: Management needs to focus more on motivating teams. Transport should be provided
Duration: <1 week
Skills evaluated in this interview
Typical DSA questions
(1 Question)
- Q1. Expected Salary
I applied via Company Website and was interviewed in May 2022. There was 1 interview round.
(1 Question)
- Q1. Tell me about your self
Interview Preparation Tips
Good company with good environment
What people are saying about Capita
I applied via Naukri.com
Interview Questionnaire
1 Question
- Q1. In technical - question related to react, redux, javascript
Capita interview questions for designations
CodingNinjas
I was interviewed before Mar 2021.
(8 Questions)
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.
- Q1. Check If The String Is A Palindrome
You are given a string 'S'. Your task is to check whether the string is palindrome or not. For checking palindrome, consider alphabets and numbers only and ignor...
- Ans.
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... - Q2. Java Question
How many types of memory areas are allocated by JVM?
- Ans.
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... - Q3. Java Question
How would you differentiate between a String, StringBuffer, and a StringBuilder?
- Ans.
1) Storage area : In string, the String pool serves as the storage area. For StringBuilder and StringBuffer, heap
memory is the storage area.
2) Mutability : A String is immutable, whereas both the StringBuilder and StringBuffer are mutable.
3) Efficiency : It is quite slow to work with a String. However, StringBuilder is the fastest in performing operations. The
speed of a StringBuffer is more than a String and less than ... - Q4. DB2 Question
Mention the way of highlighting as well as putting a CURSOR to use in a COBOL program.
- Ans.
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.
- Q5. DB2 Question
How to find the number of rows and eliminate duplicate values in a DB2 table?
- Ans.
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. - Q6. SQL Question
Write a query that joins two tables A and B having common attribute ID and selects records(ID_NAME) that have
matching ID values in both tables . - Ans.
SELECT A.ID_Name, B.ID_Name
FROM A
INNER JOIN B ON A.ID=B.ID; - Q7. DBMS Question
What is meant by normalization and denormalization?
- Ans.
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... - Q8. DBMS Question
What is Correlated Subquery in DBMS?
- Ans.
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);
(8 Questions)
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.
- Q1. Spring Boot Question
What are the major differences between RequestMapping and GetMapping?
- Ans.
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. - Q2. Spring Boot Question
How does Spring Boot works?
- Ans.
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. - Q3. Spring Boot Question
How MVC works in Spring?
- Ans.
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... - Q4. Spring Boot Question
Mention a few features of Spring Boot.
- Ans.
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... - Q5. Java Question
What are the features of a lambda expression?
- Ans.
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. - Q6. Java Question
What are some standard Java pre-defined functional interfaces?
- Ans.
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 ... - Q7. OOPS Question
Difference between Abstract class and Interface.
- Ans.
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 ... - Q8. OOPS Question
When can you use super keyword?
- Ans.
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
(1 Question)
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.
- Q1. Basic HR Questions
Why should we hire you ?
What are your expectations from the company?
How was your overall interview experience?
What are your strengths and weakness according to you?
Where do you see yourse... - Ans.
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
Interview Preparation Tips
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.
Skills evaluated in this interview
Get interview-ready with Top Capita Interview Questions
I was interviewed in Dec 2018.
Interview Questionnaire
6 Questions
- Q1. Sort using JCL and COBOL
- Ans.
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
- Q2. Cursor in DB2
- Ans.
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.
- Q3. Basic requirement to write COBOLL DB2 program
- Q4. How to remove low values while fetching data from table in DB2
- Ans.
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
- Q5. How to display values fetch from a table with alternate value
- Ans.
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
- Q6. Its all about you
Interview Preparation Tips
Duration: <1 week
Skills evaluated in this interview
Software Consultant Jobs at Capita
I was interviewed before Apr 2021.
(8 Questions)
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.
- Q1. Reverse Stack Using Recursion
Reverse a given stack of integers using recursion.
Note:
You are not allowed to use any extra space other than the internal stack space used due to recursion. You are not a... - Ans.
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... - Q2. SQL Question
Combine Two Tables
- Ans.
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 ; - Q3. Java Question
What is the difference between JDK, JRE, and JVM?
- Ans.
JVM :
1) JVM is an acronym for Java Virtual Machine; it is an abstract machine which provides the runtime environment in
which Java bytecode can be executed.
2) It is a specification which specifies the working of Java Virtual Machine. Its implementation has been provided by
Oracle and other companies. Its implementation is known as JRE.
3) JVMs are available for many hardware and software platforms (so JVM is platform depe... - Q4. Java Question
How many types of memory areas are allocated by JVM?
- Ans.
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... - Q5. Java Question
How would you differentiate between a String, StringBuffer, and a StringBuilder?
- Ans.
1) Storage area : In string, the String pool serves as the storage area. For StringBuilder and StringBuffer, heap
memory is the storage area.
2) Mutability : A String is immutable, whereas both the StringBuilder and StringBuffer are mutable.
3) Efficiency : It is quite slow to work with a String. However, StringBuilder is the fastest in performing operations. The
speed of a StringBuffer is more than a String and less than ... - Q6. Java Question
What are some standard Java pre-defined functional interfaces?
- Ans.
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... - Q7. Java Question
What are the features of a lambda expression?
- Ans.
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. - Q8. Java Question
What are the advantages of using the Optional class?
- Ans.
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.
(7 Questions)
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.
- Q1. Spring Boot Question
Explain Spring Actuator and its advantages.
- Ans.
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... - Q2. Spring Boot Question
What is the use of @Transactional annotation in spring JPA ?
- Ans.
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... - Q3. Spring Boot Question
What is Spring Batch?
- Ans.
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)... - Q4. Spring Boot Question
What are the @RequestMapping and @RestController annotation in Spring Boot used for?
- Ans.
@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... - Q5. Hibernate Question
Can you tell the difference between setMaxResults() and setFetchSize() of Query?
- Ans.
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. - Q6. Hibernate Question
What are the concurrency strategies available in hibernate?
- Ans.
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... - Q7. Hibernate Question
Explain brief about Session interface used in hibernate?
- Ans.
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 .
(2 Questions)
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.
- Q1. Basic HR Question
Tell me something not there in your resume.
- Ans.
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... - Q2. Basic HR Question
Why should we hire you?
- Ans.
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 ...
Interview Preparation Tips
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.
Skills evaluated in this interview
Interview questions from similar companies
Selected
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.
(3 Questions)
- Q1. Java code of string manipulation
- Q2. What is the Java code for various types of sorting algorithms?
- Q3. Sql query and topics related to joins.
(4 Questions)
- Q1. About yourself and family
- Q2. What do you know about the company?
- Q3. Can you provide examples of real-life scenarios where you handled conflicts with either a colleague or a manager?
- Q4. What actions would you take if your manager does not approve your product idea, and how would you attempt to persuade them?
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
(4 Questions)
- Q1. What is Dependency Injection?
- Q2. How does angular components communicate with each other?
- Q3. How can you optimize a stored procedure in MSSQL?
- Q4. What is Kestrel in .net Core?
Interview Preparation Tips
If you dont know a specific topic, dont bluff, just say so.
(2 Questions)
- Q1. Explain over all experience
- Q2. Asked question on Core and advance java topic
(2 Questions)
- Q1. Some advance topic of Java
- Q2. DSA
(2 Questions)
- Q1. Salary expectation
- Q2. Relocation
Capita Interview FAQs
Some of the top questions asked at the Capita Software Consultant interview -
Tell us how to improve this page.
Capita Interviews By Designations
- Capita Customer Service Executive Interview Questions
- Capita Software Consultant Interview Questions
- Capita Back Office Executive Interview Questions
- Capita Team Manager Interview Questions
- Capita Financial Analyst Interview Questions
- Capita Process Leader Interview Questions
- Capita Analyst Interview Questions
- Capita Assistant Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Softwaretest Engineer Interview Questions
- Software Engineer Trainee Interview Questions
- Software Developer Intern Interview Questions
- Software Developer Interview Questions
- Software Development Engineer Interview Questions
- Show more
Top Skills for Capita Software Consultant
People are getting interviews through
Interview Questions from Similar Companies
Capita Software Consultant Reviews and Ratings
based on 53 reviews
Rating in categories
|
Senior Executive
1.2k
salaries
|  ₹1.5 L/yr - ₹6.2 L/yr |
|
Softwaretest Engineer
598
salaries
| ₹2.5 L/yr - ₹8.5 L/yr |
|
Senior Software Consultant
549
salaries
| ₹8.8 L/yr - ₹26 L/yr |
|
Customer Service Executive
418
salaries
| ₹1.5 L/yr - ₹6.5 L/yr |
|
Software Consultant
395
salaries
| ₹4.5 L/yr - ₹16.2 L/yr |
Wipro
TCS
Infosys
HCLTech
Calculate your in-hand salary
- Home >
- Interviews >
- Capita Interview Questions >
- Capita Software Consultant Interview Questions
