Unify Technologies Data Scientist Interview Questions and Answers

Q1. Basic 10-15btheorotical question
Add your answer
Q2. Join + window funct question
Add your answer

Q1. Difference Between Union and Union All
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates
• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
Answered by AI
Add your answer
Q2. SQL Execution order
Add your answer
Q3. Coalesce function in SQL
Ans. 
Coalesce function in SQL is used to return the first non-null value in a list of expressions.
• Coalesce function takes multiple parameters and returns the first non-null value.

• It is commonly used to handle null values in SQL queries.

• Example: SELECT COALESCE(column_name, 'N/A') FROM table_name;
Answered by AI
Add your answer

Q1. SQL Based advanced question
Add your answer
Q2. Advanced SQL questions with Joins, Window Functions, etc
Add your answer

Q1. Basic questions on Sql
Add your answer
Q2. Few queries on CTE, JOINS, WINDOW functions
Add your answer

Q1. Similar as first row but some critical questions on sql
Add your answer

Q1. General questions about shifts and role
Add your answer

Apti questions leval medium it was easy to go for round 2

Q1. Share a video of yourself on the given topic and it should not be more than 2 mins
Add your answer

Q1. Started with self intro and projects. Coding questions based on your resume. Python preferred. Leval medium. 1 puzzel from gfg or other plateforms.
Add your answer

Easy to moderate level aptitude test
data interpretation, analytics, python, etc were asked

Q1. Speak for 2 min on a particular topic
Ans. 
The impact of social media on society
• Social media has revolutionized communication and connectivity

• It has transformed the way people interact and share information

• Social media has both positive and negative effects on society

• Examples include the spread of fake news, cyberbullying, and online activism

• It has also facilitated business growth and marketing strategies
Answered by AI
Add your answer

Q1. Technical + hr round intro projects intern ques python code 2 puzzle 1 power bi question
Add your answer