ZS Associates interview questions
Online test → Technical → Technical·97% entry level
CS fundamentals
Showing 24 of 142 reported in this area
Write SQL queries for given problems
How is React.js different from Angular.js?
Draw an ER diagram for the given databases.
Write an SQL query for a given requirement.
What is an index in SQL and what are its types?
Write SQL queries to retrieve and manipulate data
Write SQL queries based on a given database schema
Explain basic Windows-related commands used in SQL.
Answer conceptual questions on networking fundamentals.
Solve advanced SQL queries involving joins or subqueries
How and when should a machine learning model be retrained?
What techniques can be used to reduce model training time?
What is database indexing and what is database partitioning?
Write an SQL query to find the nth highest salary in a table
Write SQL queries for given business scenarios using MS Excel.
How do you select the best model and ensure optimal performance?
Write SQL queries using JOINs, GROUP BY, and aggregate functions
How can bias arise in text datasets, and how can it be mitigated?
Design a database schema following proper normalization principles
Analyze a business case study and answer multiple related questions
Write SQL queries to retrieve required output from a complex schema
Write SQL queries to retrieve the desired output from given tables.
Write SQL queries using GROUP BY, COUNT, JOINs, UNION and UNION ALL
Write SQL queries to retrieve and manipulate data from given tables.
Aptitude
Showing 10 of 105 reported in this area
Data interpretation questions based on charts and tables
Estimate the surface area of a city.
Estimate the number of traffic signals in your city.
Solve guesstimate problems involving business scenarios.
Infer insights and conclusions after reading a paragraph.
Solve large numerical aptitude problems with ambiguous data
Data interpretation questions based on charts, tables, or graphs
Estimate the total cost required to build a metro system in Delhi
Solve data interpretation problems involving quantitative analysis.
Answer guesstimate problems commonly asked in consulting interviews.
Behavioural
Showing 3 of 58 reported in this area
Describe a time when you acted as a role model for others.
Describe a situation where you faced a tight deadline for a project
Tell me about a time you worked with multiple teams to solve a problem
Puzzles
Showing 15 of 58 reported in this area
Completion of Task puzzle
Four People Rickety Bridge Puzzle
Estimate the number of trees in your city.
How many tennis balls can fit in an airplane?
Estimate the number of footballs sold in India.
Solve logical puzzles asked by the interviewer.
Explain the Monty Hall problem and its solution.
Estimate the number of street lights in your city
Estimate the total amount of petrol sold in Mumbai.
Cut a cake into 8 equal pieces using only three cuts
Solve common logical puzzles asked during interviews.
Estimate the number of red traffic signals present in your city.
Calculate the amount of paint required to paint a 20×20 feet wall.
Estimate the cost of paint required for an aircraft (guesstimate).
Measure exactly 6 liters of water using 4-liter and 9-liter buckets
DSA
Showing 5 of 25 reported in this area
Find the largest square border in a given matrix
Write a program to sort elements of any data type
Find the longest palindromic substring in a given string.
Explain Merge Sort and Quick Sort and discuss their differences.
Write a program to solve a given problem using Java or JavaScript
System design
Showing 3 of 5 reported in this area
Explain the procedure to build a notebook-based RAG (Retrieval-Augmented Generation) application.
How would you deploy a machine learning model, and what considerations are important during deployment?
How does a login page work? Explain the interaction between frontend, backend, and database during sign-in.
Showing 60 of 300 questions. Ranked by how often the same question came back across reports.
Practise a ZS Associates-style interview
A spoken interview built from these questions, scored when you finish; the report is yours.
Start practisingCommon questions
What questions does ZS Associates ask?
Candidate interview reports most often cover CS fundamentals (36%) and Aptitude (27%).
How many rounds does ZS Associates interview have?
Candidate interview reports show an average of 4.4 rounds per experience, with a typical sequence of Online test → Technical → Technical. Individual interview paths can vary.
Is the ZS Associates interview hard?
Among questions with a reported difficulty, the mix is easy 33%, medium 62%, hard 5%.