Random Trees Data Analyst Interview Questions and Answers

1 python question and 1 sql question for coding and rest were the mcqs based on sql and python.

Q1. Python code was asked for checking the anagrams
Add your answer
Q2. Sql code asked to solve on screen share using various use cases like group by, having, count
Add your answer

Q1. Python code was asked for swaping any number but without using python libraries
Add your answer
Q2. Sql code was asked using concepts of rank dense,rank, partition by
Add your answer

DURATION 1.3 HRS WITH REASONING AND 2 CODING QUESTION

Q1. SQL QUESTION FIND N TH HIGHEST SALARY
Ans. 
Use SQL query with ORDER BY and LIMIT to find the Nth highest salary.
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT to specify the Nth highest salary

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT N,1
Answered by AI
Add your answer
Q2. SQL QUESTION PIVOT TABLE QUESTION
Add your answer

Q1. Any question wtihtout i'm very honested and cearfully
Add your answer
Q2. My goal setting and my hobby ect.
Add your answer

The aptitude test consists of MCQ on computer technicals , english, verbals, etc as like usual aptitude test. Also it includes 2-3 sql queries to solve as well as 1-2 coding questions with easy to medium level difficulty.

Q1. Technical round was around 1 hour. They had asked me the technical questions related to computer fundamentals like networking, DS, OOP, etc. Then he went on java code and their programming basics like adap...read more
Add your answer

Q1. HR was the telephonic round for me. They just asked normal hr questions like intro, strengths, weakness, location preferences, technologies on which i had worked on etc. They have also gave me the CTC info...read more
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. Basic to Intermediate SQL Based questions
Add your answer
Q2. Basic to Intermediate Python Based questions
Add your answer

It was a test of 90 minutes containing almost every thing .Quantitative+Logical+Computer fundamentals+2 coding questions