Celebal Technologies Data Analyst Interview Questions, Process, and Tips

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

Consisting of around 10 SQL querying questions and 2 Python programming questions and 30 SQL + PowerBI related MCQs

Q1. SQL related questions
Add your answer
Q2. Questions on ETL and Bigdata
Add your answer
Q3. Resume related questions
Add your answer

Q1. Company policies and work culture explanation and acceptance to work
Add your answer

It contain MCQ question which contain F section but all are easy. It contain some coding problem of easy, medium and hard level of Data structure and problems related to your domain.

Q1. They mainly asked the question related to your Domain.
Add your answer
Q2. SQL, DS,OOPS,DBMS etc.
Add your answer

Q1. HR only asked about yourself and offered you a salary.
Add your answer