Celebal Technologies Associate Consultant Interview Questions and Answers

Basic coding questions

Given a topic and asked to speak about it. half members are supporting the statement, half are against the statement

Q1. Questions based on resume
Add your answer
Q2. Linked list code
Add your answer
Q3. Sql query for salary of the employee
Ans. 
Use SQL query to retrieve the salary of an employee.
• Use SELECT statement to retrieve the salary column from the employee table.

• Specify the employee's ID or name in the WHERE clause to filter the results.

• Consider joining the employee table with other tables if necessary.

• Use appropriate functions like SUM, AVG, MAX, MIN if needed.

• Example: SELECT salary FROM employee WHERE employee_id = 123;
Answered by AI
Add your answer

Q1. Where do u see your self in 5 years
Add your answer
Q2. Do you think you are a good fit
Add your answer

Hackerrank level 1 with 3 programming questions and 10 multiple choice questions

Q1. Technical HR was conducted asked about java and SQL concept and was said to write a java program
Add your answer
Q2. Java string concepts
Add your answer

Q1. About Java Collections, features and more depth about Java 8.
Add your answer
Q2. SpringBoot features and annotations and dependency injection.
Add your answer
Q3. About previous project and tools used as part of Development.
Add your answer

Covers the simple aptitude question and basic CS fundamental and oops concepts.

Q1. Give some code example and asked to say the output. Indetail about oops and DBMS concepts.
Add your answer

Q1. Intro and some group discussion with the HR about the company.
Add your answer