Astegic Interview Questions, Process, and Tips

Question were related to sql and power bi

Have to complete the assignment.

Q1. One on one round with manager.
Add your answer

Q1. Delete drop truncate
Add your answer
Q2. Basic joins and their usage
Ans. 
Basic joins are used to combine rows from two or more tables based on a related column between them.
• Types of basic joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left...read more
Answered by AI
Add your answer

Q1. Difference between UNION and UNION ALL
Ans. 
UNION combines and removes duplicates, UNION ALL combines without removing duplicates.
• UNION merges the result sets of two or more SELECT statements and removes duplicates

• UNION ALL merges the result sets of two or more SELECT statements without removing duplicates

• UNION is slower as it has to remove duplicates, while UNION ALL is faster as it does not have to check for duplicates
Answered by AI
Add your answer

A SQL based assignment containing 8 SQL questions ranging from easy to moderate levels.

Q1. What is linkedin
Ans. 
LinkedIn is a professional networking platform where users can connect with colleagues, find job opportunities, and share industry insights.
• Professional networking platform

• Connect with colleagues and industry professionals

• Find job opportunities

• Share industry insights and updates
Answered by AI
View 1 more answer