Celebal Technologies Associate Interview Questions and Answers

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

Moderate DSA questions

Q1. ML related basic question.
Add your answer

Q1. Project discussion and final round
Add your answer

Random SQL and python Questions

Q1. Questions on the selected tech stack
Add your answer