Company Capita
I applied for this company via Naukri.com
Round 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.