Swiggy Interview Questions, Process, and Tips

8 sql questions
1 hard, 4 easy and 3 medium

Q1. Tell me about yourself. Your responsibilities in current role.
Ans. 
I am a Business Analyst with experience in data analysis, process improvement, and stakeholder management.
• Analyze data to identify trends and insights

• Improve business processes through automation and optimization

• Manage relationships with stakeholders to gather requirements and ensure project success
Answered by AI
Add your answer
Q2. SQL based basic questions. Output of left join and inner right join
Add your answer
Q3. Any notable project you’ve done which made any remarkable change in business
Ans. 
Implemented a data analytics project that optimized inventory management, resulting in a 20% reduction in costs.
• Analyzed historical sales data to forecast demand and optimize inventory levels

• Implemented a new inventory management system based on data-driven insights

• Collaborated with cross-functional teams to ensure successful implementation

• Monitored key performance indicators to track the impact of the project
Answered by AI
Add your answer
Q4. Difference between DDL and DML
Ans. 
DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.
• DDL is used to create, modify, and delete database objects like tables, indexes, etc.

• DML is used to insert, update, delete, and retrieve data from the database.

• Examples of DDL statements include CREATE TABLE, ALTER TABLE, DROP TABLE...read more
Answered by AI
Add your answer
Q5. How null behaves in different types of joins
Ans. 
Null behaves differently in different types of joins in SQL
• In INNER JOIN, rows with NULL values are excluded from the result set

• In LEFT JOIN, rows with NULL values from the left table are included in the result set

• In RIGHT JOIN, rows with NULL values from the right table are included in the result set

• In FULL OUTER JOIN, rows with NULL values from either table are included in the result set
Answered by AI
Add your answer

Q1. Array duplicate method using (Linked list)Hash Set
Add your answer
Q2. Arrays of integers an integer Target indicates a two input numbers in array input num = [2,7,11,15] target 9 output [0,1]
Add your answer
Q3. Basic Testing QA & write a Scenario and testcase for a Website
Add your answer

1. PEAK ELEMENT QUESTION.
2. COIN DENOMINATION

Test your English language

Q1. Tell me about your self
Ans. 
I am a dedicated and experienced Online Reputation Management Executive with a proven track record of improving and maintaining positive online presence for clients.
• Over 5 years of experience in managing online reputation for various clients

• Skilled in utilizing social media platforms and SEO strategies to enhance online reputation

• Successfully handled crisis management situations and turned negative feedback into positi
Answered by AI
Add your answer