Celebal Technologies Associate Interview Questions and Answers

Q1. It's one to one round with interviewer
Add your answer
Q2. ADF, SQL, Python, Spark, Azure
Add your answer

Data structure and algorithms

Q1. Related to the specific technologies
Add your answer

Q1. Job profile, salary discussion, and company culture
Add your answer

Q1. About joins in sql
Add your answer
Q2. Question on the group by and having clause.
Add your answer

Q1. About yourself.
Add your answer
Q2. Strength and weakness
Add your answer

Q1. What are joins in sql ?
Ans. 
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

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. What is difference between duplicate and reference ?
Ans. 
Duplicate is an exact copy of something, while reference is a pointer to the original object.
• Duplicate is a separate copy of the original item, while reference points to the original item.

• Changes made to a duplicate do not affect the original, but changes made to a reference affect the original.

• Duplicate has its own memory space, while reference shares memory space with the original object.
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated and hardworking individual with a passion for learning and growth.
• I have a background in marketing and have worked in the industry for 5 years.

• I am currently pursuing a Master's degree in Business Administration to further my skills and knowledge.

• I am a team player and enjoy collaborating with others to achieve common goals.
Answered by AI
Add your answer
Q2. Salary expectation
Add your answer