Capita India Interview Experience

Company Capita

I applied for this company via Naukri.com

Round 1:

1. DSA: Code for the following question

input : string s1 = encode(“aaabbccaadddd”);

output : s1 = 3a2b2c2a4d

2. How can u ensure that the class has only one object- a singleton class 

3.  If u have a student table and a student course table, how will you fetch info from both the tables at same time – joins the concept

4. In-depth of right join and left joins. Outer joins

5. What are aggregate functions and how can u find max marks from the employee table?

SELECT a.city, MAX(marks) AS topper_marks

FROM address a

INNER JOIN marks m ON a.address_id = m.address_id

GROUP BY a.city

ORDER BY topper_marks DESC;

6. Can we use having or grouping by aggregate functions? What if you just need to find marks greater than 90 from the student table after you have found max marks?

SELECT a.city, MAX(marks) AS topper_marks

FROM address a

INNER JOIN marks m ON a.address_id = m.address_id

Round 2 :

General discussion on Projects made, hobbies, and basic LinkedList problems.