Capermint Technologies Private Limited Senior Consultant Interview Questions and Answers

Q1. Nvl and nvl2 difference Some practical queries on SQL Performance tunning Trigger
Add your answer
Q2. Abstract class vs interface Internal working of hashmap Java 8 fearures
Ans. 
Questions on abstract class vs interface, internal working of hashmap, and Java 8 features.
• Abstract class is a class that cannot be instantiated and can have both abstract and non-abstract methods.

• Interface is a collection of abstract methods and constants that can be implemented by a class.

• HashMap is a data structure that stores key-value pairs and uses hashing to retrieve values.

• Java 8 introduced features like lambda...read more
Answered by AI
Add your answer

Q1. Technical discussion was per resume.
Add your answer

Q1. General questions on past experiences and future aspirations.
Add your answer

Will be given Requirement to write code for Restraunt. Based on that have write code for delivering orders by delivery boys.

Q1. OOPS Concepts, Java Basics, Collections, MultiThreading
Add your answer

Assignment to develop a prototype

Q1. Face to face questions
Add your answer
Q2. Java Question Technical & coding
Add your answer
Q3. Mongodb & Mysql Question
Add your answer

15 objective questions related to basic DSA, OOPS

Q1. Explain your one of the project , cross questions around project
Add your answer
Q2. OS, DBMS & One medium complex coding question
Add your answer

Q1. Introduce yourself & explain your fav. project.
Add your answer
Q2. One coding question related to sorting & hashing, i have to share my screen and discuss all possible approaches & then write code for optimum approach.
Add your answer

Nuts and bolts game, to output date in a certain format, one SQL query

Q1. Stacks and Queues
Add your answer
Q2. Linked lists, arrays, and many more basic fundamental Dsa questions.
Add your answer

Q1. More about your resume projects.
Add your answer
Q2. Puzzles and reasoning is asked
Add your answer

DSA based round. Taken by external company. I would say to medium level questions asked.

Q1. This was based on LLD.
Add your answer
Q2. Why SQL and not NoSQL?
Ans. 
SQL is preferred for structured data, transactions, complex queries, and ACID compliance.
• SQL is better for structured data and relationships between data.

• SQL is preferred for transactions and ensuring data integrity.

• SQL is more suitable for complex queries involving multiple tables.

• SQL databases provide ACID compliance for data consistency and reliability.
Answered by AI
Add your answer

Q1. Past project experience with a Tech Lead.
Ans. 
Worked on a project with a Tech Lead to develop a new feature for a web application.
• Collaborated closely with the Tech Lead to define project requirements and timelines

• Received guidance and mentorship from the Tech Lead on best practices and coding standards

• Participated in regular code reviews and discussions with the Tech Lead to ensure quality and consistency

• Implemented feedback and suggestions provided by the Tech L
Answered by AI
Add your answer
Q2. More into the problems I have solved previously and the working culture discussion.
Add your answer

Q1. There wer four questions 1) wildcard pattern matching(leetcode) 2) cows and buffaloes(leetcode) 3) unix based cd directory 4) backtracking question
Add your answer
Q2. It was a resume based round for 45 min
Add your answer

Q1. It was a resume based round for 1 hr
Add your answer