Celebal Technologies Interview Questions, Process, and Tips

Q1. Form was shared with basic questions like why do want to join this Center of Excellence (COE) program ?
Add your answer
Q2. How will you benefit from the training/internship?
Ans. 
I will benefit from the training/internship by gaining valuable hands-on experience, expanding my skill set, and building a professional network.
• Gain practical experience in the field

• Develop new skills and knowledge

• Build a network of professionals for future opportunities
Answered by AI
Add your answer
Q3. Choices were given between data science and data engineering?
Ans. 
Data science focuses on analyzing and interpreting complex data, while data engineering focuses on designing and building data pipelines.
• Data science involves analyzing and interpreting large amounts of data to extract insights and make predictions.

• Data engineering involves designing and building data pipelines to collect, store, and process data efficiently.

• Data scientists use tools like Python, R, and machine learnin...read more
Answered by AI
Add your answer

People were shortlisted from the previous round of applications and seperated in group of 8 for GD with alloted timings in entire day.

Communication and English speaking skills were main focus. Topics were very common standard topics available in interviewbit, GFG etc. Not on any current trending topic. Easy if you have prepared on common topics.

Entire group had 1 hour to complete.

Q1. What are advance types of join ?
Ans. 
Advanced types of join include outer join, self join, and cross join.
• Outer join: includes unmatched rows from one or both tables

• Self join: joins a table with itself

• Cross join: combines each row from one table with each row from another table
Answered by AI
Add your answer
Q2. Difference between having clause and where clause?
Ans. 
The WHERE clause is used to filter rows before grouping, while the HAVING clause is used to filter groups after grouping.
• WHERE clause is used with SELECT, UPDATE, and DELETE statements.

• HAVING clause is used with SELECT statements that include GROUP BY clause.

• WHERE clause filters individual rows based on conditions.

• HAVING clause filters groups based on conditions.

• WHERE clause is applied before the GROUP BY clause.

• HAVING...read more
Answered by AI
Add your answer
Q3. Differnce between join and union?
Ans. 
Join combines rows from two or more tables based on a related column, while union combines rows from two or more tables into a single result set.
• Join is used to combine rows from different tables based on a related column.

• Union is used to combine rows from two or more tables into a single result set.

• Join can be used with different types like inner join, left join, right join, etc.

• Union only combines rows with the same ...read more
Answered by AI
Add your answer
Q4. Basic oops concept ?
Add your answer
Q5. What are python data structure?
Ans. 
Python data structures are containers that hold and organize data in different ways.
• Some common Python data structures are lists, tuples, sets, and dictionaries.

• Lists are ordered and mutable, allowing duplicate elements.

• Tuples are ordered and immutable, useful for storing related data together.

• Sets are unordered and contain unique elements, useful for mathematical operations.

• Dictionaries are key-value pairs, providing
Answered by AI
Add your answer

Q1. Tell me something about yourself
Add your answer
Q2. Would you be able to commute to jaipur
Add your answer

Aptitude questions and normal maths, logical questions

3 coding question of different level

It is an online coding test and the duration is 3 hours. They test your python skills here. Questions are related to Python and Pandas. You have to write code for the given questions.

Q1. Few basic python programs related to lists, data structures, strings, Fibonacci series etc
Add your answer
Q2. Asked ML related questions like regression, classification algorithms, NLP questions, evaluation metrics, how to handle if there are many attributes in dataset etc
Add your answer

It was very easy and out of 1000 students 300 students got shortlisted.

Q1. It was also easy and out of 300 students 30 got shortlisted.
Add your answer
Q2. What are oops? Explain 4 pillars
Ans. 
OOPs stands for Object-Oriented Programming. The 4 pillars are Inheritance, Encapsulation, Abstraction, and Polymorphism.
• Inheritance: Allows a class to inherit properties and behavior from another class. Example: Parent class 'Animal' and child class 'Dog' inheriting from 'Animal'.

• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: Using private variables and public methods in...read more
Answered by AI
Add your answer
Q3. What is DBMS and SQL?
Ans. 
DBMS stands for Database Management System, which is a software system that manages databases. SQL is a language used to interact with databases.
• DBMS is a software system that allows users to define, create, maintain, and control access to databases.

• SQL (Structured Query Language) is a language used to communicate with a database. It is used to retrieve, update, and manage data in a database.

• Examples of popular DBMS in...read more
Answered by AI
Add your answer
Q4. What is MongoDB? Explain it.
Ans. 
MongoDB is a NoSQL database program that uses a document-oriented data model.
• NoSQL database program

• Document-oriented data model

• Uses JSON-like documents for data storage

• Supports dynamic schemas for flexible data structures
Answered by AI
Add your answer
Q5. Explain all hooks of React.
Ans. 
React hooks are functions that let you use state and other React features without writing a class.
• Hooks are functions that let you use state and other React features in functional components

• useState() - allows functional components to have local state

• useEffect() - allows functional components to perform side effects

• useContext() - allows functional components to access context

• useReducer() - an alternative to useState() ...read more
Answered by AI
Add your answer