Swiggy MIS Executive and Analyst Interview Questions and Answers

Basics Aptitude & Personality Test

Q1. Union Vs Union All
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates.
• Union is used to combine the result sets of two or more SELECT statements and removes duplicates.

• Union All is used to combine the result sets of two or more SELECT statements without removing duplicates.

• Union is slower than Union All because it has to remove duplicates.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM tabl...read more
Answered by AI
Add your answer
Q2. Scenario based Q.s on Excel & SQL
Add your answer

Q1. Salary Negotiation
Add your answer

Q1. My previous company roles and responsibilities
Ans. 
I was responsible for managing and analyzing data as an MIS Executive and Analyst.
• Managed and maintained databases to ensure accurate and up-to-date information.

• Analyzed data to identify trends, patterns, and insights for decision-making purposes.

• Generated reports and dashboards to present data findings to management.

• Collaborated with cross-functional teams to gather data requirements and provide data-driven solutions.

• ...read more
Answered by AI
View 2 more answers

They are given 10 questions i have confused some questions

Q1. SQL why u using left join
Ans. 
LEFT JOIN is used to retrieve all records from the left table and matching records from the right table.
• Used when we want to retrieve all records from the left table and matching records from the right table

• Helpful when we want to include all records from one table and only matching records from another table

• Can be used to find records with NULL values in the right table
Answered by AI
Add your answer

Q1. Questions related to work
Add your answer