Celebal Associate Consultant Interview Questions and Answers

Aptitude round consists Logical reasoning, General Aptitude, Grammar related questions etc. All are moderate level questions.

Q1. Explain OOPs w.r.t Java
Ans. 
OOPs is a programming paradigm that uses objects to represent real-world entities. Java is an OOPs language.
• OOPs stands for Object-Oriented Programming System

• Java is a class-based OOPs language

• Encapsulation, Inheritance, Polymorphism, and Abstraction are the four pillars of OOPs

• Objects have state and behavior

• Java supports interfaces, which allow for multiple inheritance

• Example: A car can be represented as an object wit...read more
Answered by AI
Add your answer
Q2. Explain about the projects that you have worked on
Add your answer
Q3. Explain how Java solves machine dependency of code execution
Ans. 
Java solves machine dependency by using bytecode and virtual machine.
• Java code is compiled into bytecode which is platform-independent

• The bytecode is executed by the Java Virtual Machine (JVM) which is platform-specific

• JVM translates bytecode into machine code for the specific platform

• This allows Java code to run on any platform with a JVM installed

• Example: A Java program compiled on Windows can run on Linux or Mac as
Answered by AI
Add your answer

Q1. Why should we hire you?
Add your answer
Q2. Tell me about yourself.
Add your answer

The medium level questions are present

There was no gd

Q1. What is your family background?
Add your answer
Q2. Why should we hire you?
Add your answer
Q3. What are your strengths and weaknesses?
Add your answer
Q4. Tell me about yourself.
Add your answer
Q5. Hr round and the technical discussion was combined into one round
Add your answer

Numerical ability and logical reasoning followed by some coding mcqs

Q1. Print 1 to 100 without for loop
Ans. 
Printing 1 to 100 without for loop
• Use recursion to print numbers from 1 to 99

• Print 100 outside the recursion

• Use a base case to stop recursion at 100
Answered by AI
Add your answer

Simple aptitude test

Q1. General questions as per your cv
Add your answer

Q1. Why do you want to join infosys
Add your answer
Q2. Product developement life cycle
Ans. 
Product development life cycle is the process of bringing a new product to market.
• It involves ideation, research, design, development, testing, launch, and post-launch evaluation.

• Each stage has its own set of goals, deliverables, and stakeholders.

• Examples include Apple's iPhone development cycle and the pharmaceutical drug development cycle.
Answered by AI
Add your answer

Attended the codevita competition in final year of college.

Q1. About College Project
Add your answer
Q2. Some very basics of java
Add your answer
Q3. Experience of college project as a team
Add your answer

Q1. Write a program to find out given number is palindrome number or not
Ans. 
Program to check if a given number is a palindrome or not.
• Convert the number to a string

• Reverse the string

• Compare the reversed string with the original string

• If they are equal, the number is a palindrome
Answered by AI
Add your answer
Q2. Write Sql query for join
Ans. 
SQL query for join
• Use JOIN keyword to combine rows from two or more tables based on a related column

• Specify the columns to be selected using SELECT keyword

• Use ON keyword to specify the join condition

• Types of join: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN

• Example: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q3. Event loop in nodejs
Ans. 
Event loop is a mechanism in Node.js that allows non-blocking I/O operations to be performed efficiently.
• Event loop is responsible for handling all the I/O operations in Node.js

• It is a single-threaded loop that constantly checks for new events in the event queue

• When an event is detected, the corresponding callback function is executed

• Event loop allows Node.js to handle multiple requests simultaneously without blocking ...read more
Answered by AI
Add your answer

Q1. How to write test cases in nodejs
Ans. 
Test cases in Node.js can be written using testing frameworks like Mocha, Jest, and Chai.
• Choose a testing framework that suits your project requirements

• Write test cases for each function or module in your code

• Use assertions to check if the expected output matches the actual output

• Mock external dependencies to isolate the code being tested

• Run tests using the testing framework's command line interface or integration with
Answered by AI
Add your answer
Q2. Difference between java and nodejs
Ans. 
Java is a statically typed language while Node.js is a runtime environment for JavaScript.
• Java is compiled while Node.js is interpreted

• Java is better for large-scale enterprise applications while Node.js is better for real-time applications

• Java has a larger community and more libraries while Node.js has a simpler and more lightweight architecture

• Java is used for Android app development while Node.js is used for server-...read more
Answered by AI
Add your answer
Q3. What is agile process
Ans. 
Agile process is an iterative approach to software development that emphasizes flexibility, collaboration, and customer satisfaction.
• Agile process involves breaking down a project into smaller, manageable chunks called sprints

• Each sprint involves planning, designing, coding, testing, and reviewing

• Agile process emphasizes continuous feedback and adaptation to changing requirements

• Examples of agile methodologies include
Answered by AI
Add your answer
Q4. Which Deployment method/tool used for code deployment
Ans. 
There are various deployment methods/tools available such as Jenkins, Ansible, Docker, Kubernetes, etc.
• Jenkins is a popular tool for continuous integration and deployment

• Ansible is a configuration management tool that can also be used for deployment

• Docker and Kubernetes are containerization tools that can simplify deployment

• Deployment methods can vary depending on the technology stack and infrastructure

• Deployment can b
Answered by AI
Add your answer
Q5. Mongodb database advantage and disadvantage
Ans. 
MongoDB is a NoSQL database with flexible schema and high scalability, but lacks transaction support.
• Advantages: flexible schema, high scalability, easy to use, supports sharding and replication

• Disadvantages: lacks transaction support, not suitable for complex transactions, limited query functionality compared to SQL databases

• Example: MongoDB is used by companies like eBay, Forbes, and The Guardian for their high scala
Answered by AI
Add your answer

Q1. Why are you looking for a change?
Add your answer
Q2. What are your salary expectations?
Add your answer

It was a basic aptitude test.

Q1. Interview was fine. Mostly asked about my final year project.
Add your answer