ZS Interview Questions, Process, and Tips

Algebra questions were asked related to time speed and distance

SQL and Python questions

Reasoning ,English,Guessttimates

Q1. Puzzles related to maths
Add your answer
Q2. Why wanna join consulting
Add your answer

Q1. Joins SQL detail
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

• 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
Q2. Project in derail
Ans. 
When a project is in derail, it means it is off track and not progressing as planned.
• Identify the root cause of the derailment

• Reassess project goals and timeline

• Implement corrective actions to get the project back on track

• Communicate with stakeholders about the situation and the plan moving forward
Answered by AI
Add your answer

Verabal , Logical Aptitude

English (Vocabulary , Pronunciation)

Q1. Sql Questions , Puzzles , Project Discussion
Add your answer

Q1. Behavioral Question
Add your answer

SQL adn Python and Power BI

Q1. What your experience
Ans. 
I have over 10 years of experience in management roles, leading teams to success through strategic planning and effective communication.
• Managed teams in various industries including retail, healthcare, and technology

• Developed and implemented strategic plans to achieve company goals

• Strong communication skills to effectively lead and motivate team members

• Experience in budgeting, forecasting, and performance evaluation

• Led...read more
Answered by AI
Add your answer
Q2. What is sql? Explain in detail
Ans. 
SQL is a programming language used for managing and manipulating databases.
• SQL stands for Structured Query Language

• It is used to communicate with databases to perform tasks such as querying data, updating data, and creating databases

• Common SQL commands include SELECT, INSERT, UPDATE, DELETE

• Example: SELECT * FROM customers WHERE city = 'New York'
Answered by AI
Add your answer

Logical and quant questions

3 coding question 2 sql questions

Round 1 was Aptitude which is not an elimination round, Round 2 was communication round in which you have to listen to the audios and write the answers accordingly.

After result of round 2 and 3,, there is round 3 which is case study round. Round 1, 2 and 3 are online tests.