Dunzo Analyst Intern Interview Questions and Answers

Define CTE and how it works

Q1. Tell me about yourself
Add your answer
Q2. Why swtiching your company
Add your answer

Given a on spot question and we have to solve the problem. As i attended for MIS Job its in Excel. They have a set of questions in that question will be like basic to advanced formulas. We have to solve infront of Interviewer.

Q1. Self introduction and knowledge checking
Add your answer

Q1. SQL and Excel based questions
Add your answer

Q1. Rank Function Application in Google Sheet?
Ans. 
Rank function in Google Sheets is used to assign a rank to a value in a list based on its order.
• Rank function is used to determine the rank of a value in a list.

• It can be used to rank values in ascending or descending order.

• The syntax for the rank function is RANK(value, range, [is_ascending]).
Answered by AI
Add your answer
Q2. Joins From 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
Q3. Order Of query execution in SQL?
Ans. 
The order of query execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
• FROM: Specifies the tables from which data will be retrieved.

• WHERE: Filters the rows based on specified conditions.

• GROUP BY: Groups the rows based on specified columns.

• HAVING: Filters the groups based on specified conditions.

• SELECT: Retrieves the columns specified in the query.

• ORDER BY: Sorts the result set based on specified column
Answered by AI
Add your answer
Q4. Write a query to find out students has greater than 80 marks and from English subject?
Ans. 
Query to find students with over 80 marks in English subject
• Use SELECT statement to retrieve data

• Filter the results using WHERE clause for marks greater than 80

• Include condition for English subject using AND operator
Answered by AI
Add your answer

Q1. When we use having clause ?
Ans. 
HAVING clause is used in SQL to filter groups based on specified conditions after GROUP BY clause.
• HAVING clause is used with GROUP BY clause to filter groups based on specified conditions.

• It is used to filter the results of aggregate functions like COUNT, SUM, AVG, etc.

• It is used to apply conditions to groups, similar to WHERE clause which applies conditions to individual rows.

• Example: SELECT department, AVG(salary) FR...read more
Answered by AI
Add your answer
Q2. Aggregate Function Application?
Ans. 
Aggregate functions are used to perform calculations on groups of rows in a table.
• Aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• They are commonly used in SQL queries to summarize data.

• For example, you can use SUM to calculate the total sales for a specific product.

• Another example is using AVG to find the average salary of employees in a department.
Answered by AI
Add your answer
Q3. Group by and order By?
Add your answer
Q4. Write a query employes join between such dates?
Ans. 
Use a SQL query with JOIN to retrieve employees between specified dates.
• Use the JOIN keyword to combine data from two tables

• Specify the date range using the WHERE clause

• Example: SELECT * FROM employees e JOIN dates d ON e.date = d.date WHERE d.date BETWEEN '2022-01-01' AND '2022-12-31'
Answered by AI
Add your answer

Asking about ur self introduction and work experience

Q1. Map implementation
Add your answer
Q2. Oops questions, exception handling
Add your answer

Q1. How much support does a CRO give to the company to do more business and how?
Add your answer
Q2. How to advance company productivity through marketing?
Ans. 
Company productivity can be advanced through marketing by increasing brand awareness, targeting the right audience, utilizing digital marketing strategies, and analyzing data for optimization.
• Increase brand awareness through targeted advertising campaigns

• Target the right audience through market research and segmentation

• Utilize digital marketing strategies such as social media, email marketing, and SEO

• Analyze data to op
Answered by AI
Add your answer

Q1. Tell something about yourself
Ans. 
I am a dedicated and hardworking individual with a passion for learning and growth.
• I have a Bachelor's degree in Business Administration

• I have 3 years of experience in marketing and sales

• I am fluent in English, Spanish, and French
Answered by AI
Add your answer
Q2. Previous job experience
Ans. 
I have 5 years of experience working in marketing and sales roles at a Fortune 500 company.
• Managed marketing campaigns and strategies to increase brand awareness

• Developed sales tactics to drive revenue growth

• Collaborated with cross-functional teams to achieve business objectives
Answered by AI
Add your answer

Q1. What was your job role in previous company?
Ans. 
I was responsible for managing the marketing campaigns and social media presence of the company.
• Managed marketing campaigns to increase brand awareness

• Handled social media accounts to engage with customers

• Analyzed data to measure the effectiveness of marketing strategies
Answered by AI
Add your answer
Q2. How you handle the customer on calls?
Ans. 
I handle customer calls by actively listening, empathizing with their concerns, and providing solutions in a professional and friendly manner.
• Active listening to understand the customer's issue

• Empathizing with the customer's concerns to show understanding

• Providing solutions or assistance in a professional and friendly manner

• Ensuring clear communication and follow-up if needed
Answered by AI
Add your answer

Q1. Why you left the previous job?
Ans. 
Seeking new challenges and opportunities for growth.
• Desire for career advancement

• Seeking new challenges

• Opportunity for professional growth

• Company restructuring

• Relocation
Answered by AI
Add your answer
Q2. Anything you would like to ask?
Add your answer

Q1. When are you working in Warehouse?
Add your answer
Q2. What do you do in the warehouse?
Add your answer