Celebal Technologies Consultant Interview Questions and Answers

A comprehensive banking application with features like account management, transactions, loans, and customer support.

• Include features for account creation, management, and transactions

• Implement secure login and authentication methods

• Incorporate loan application and approval processes

• Provide customer support through chat or call center

• Include features for bill payments, fund transfers, and account statements

I currently live in a bustling city with easy access to public transportation and amenities.

• I live in a city with a population of over 1 million people

• I have access to public transportation such as buses and trains

• There are plenty of amenities nearby such as grocery stores, restaurants, and parks

Developed a project management tool for tracking tasks and deadlines

• Created a user-friendly interface for inputting and monitoring project tasks

• Implemented a notification system for upcoming deadlines

• Integrated a calendar feature for visualizing project timelines

Dependency injection is a design pattern in which components are given their dependencies rather than creating them internally.

• Dependency injection helps in achieving loose coupling between classes.

• It allows for easier testing by providing a way to mock dependencies.

• There are three types of dependency injection: constructor injection, setter injection, and interface injection.

Template driven and reactive form example in Angular

• Use Angular's FormsModule and ReactiveFormsModule modules

• Create form controls using ngModel or formControl directives

• Implement form validation using built-in validators or custom validators

• Handle form submission using reactive approach with observables

Collection is a framework that provides an architecture to store and manipulate a group of objects. StringBuilder and StringBuffer are classes used for manipulating strings, with StringBuffer being thread-safe.

• Collection is a framework in Java used to store and manipulate groups of objects.

• StringBuilder and StringBuffer are classes used for manipulating strings in Java.

• The main difference between StringBuilder and Stri...read more

Joins in SQL are used to combine rows from two or more tables based on a related column between them.

• Joins are used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN re...read more