Junglee Games Production Analyst Interview Questions and Answers

10 questions - 45minutes

Q1. SQL joins based questions
Add your answer
Q2. Excel VLOOKUP function
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 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

Moderate level with mix of all the topics in the aptitude

Q1. Here they tested our communication skill in which we were asked to record a selfie video telling about a certain topic which will be given my the interviewers
Add your answer

Q1. Was asked about python , sql , aptitude and puzzles
Add your answer

Q1. Related to Role and CV
Add your answer

Q1. With the client. Current roles and responsibility and technical.
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