ZS
100+ CMA CGM Interview Questions and Answers
Q1. 3 ants are sitting on the vertices of an equilateral triangle and they start moving in a random direction along its perimeter. What is the probability of any 2 ants colliding?
The probability of any 2 ants colliding is 1/3.
There are 3 possible pairs of ants that can collide.
Each ant has 2 possible directions to move in.
The total number of possible outcomes is 2^3 = 8.
Out of the 8 possible outcomes, 3 result in collision.
Therefore, the probability of collision is 3/8 or 1/3.
Q2. Ways To Make Coin Change
Given an infinite supply of coins of varying denominations, determine the total number of ways to make change for a specified value using these coins. If it's not possible to make the c...read more
The task is to determine the total number of ways to make change for a specified value using given denominations of coins.
Create a function that takes the number of denominations, the denominations array, and the value to make change for as input parameters.
Use dynamic programming to iterate through all possible combinations of coins to make the change.
Keep track of the number of ways to make change for each value from 0 to the target value.
Return the total number of ways to ...read more
Q3. A person wants to open a zoo in Mumbai, for which they'll have to import animals from South Africa, should they open the zoo?
Yes, they should open the zoo.
Opening a zoo in Mumbai can be a profitable business venture.
Importing animals from South Africa can attract visitors and enhance the zoo's appeal.
The zoo can contribute to conservation efforts by raising awareness about endangered species.
Proper planning and adherence to legal and ethical guidelines are essential.
Market research and feasibility studies should be conducted to ensure long-term success.
Q4. Kevin and His Cards Problem Statement
Kevin has two packs of cards. The first pack contains N cards, and the second contains M cards. Each card has an integer written on it. Determine two results: the total num...read more
Find total distinct card types and common card types between two packs of cards.
Create a set to store distinct card types when combining both packs.
Iterate through each pack and add card types to the set.
Find the intersection of card types between the two packs to get common card types.
Q5. 10 coins. 5 Heads up. Make 2 piles blindfolded with equal number of heads up
Divide 10 coins with 5 heads up into 2 piles with equal number of heads up while blindfolded.
Divide the coins into two equal piles of 5 coins each.
Ensure that each pile has the same number of heads up coins.
Since you are blindfolded, you can't rely on visual cues, so use your sense of touch to determine which coins are heads up.
You can also flip the coins over and feel for the heads to ensure equal distribution.
Alternatively, you can ask someone else to divide the coins for y...read more
Q6. Ants on corners of equilateral triangle. Probability they will not collide moving along the edges
Probability of non-collision of ants on corners of equilateral triangle.
The ants can move in two directions along each edge.
The probability of collision is 1/3.
The probability of non-collision is 2/3.
Use SQL query to generate a report of customer churn based on case study data.
Identify the criteria for customer churn in the case study data (e.g. last purchase date, account status)
Select the relevant fields from the database tables (e.g. customer ID, churn date)
Filter the data to include only customers who meet the churn criteria
Group the data by relevant time periods (e.g. monthly, quarterly) to analyze churn trends
Calculate the churn rate by dividing the number of churne...read more
Q8. Diagonal Order Problem Statement
Given a 2D matrix, output all elements of the matrix in diagonal order, starting from the top-left element and proceeding diagonally.
Input:
Line 1: Two integers, R and C, denot...read more
The problem involves outputting elements of a 2D matrix in diagonal order, alternating directions.
Iterate through the matrix diagonally, starting from the top-left element.
Alternate the direction of traversal from bottom-left to top-right and vice versa.
Handle large matrices efficiently by taking advantage of matrix properties.
Example: For a 3x3 matrix [1, 2, 3, 4, 5, 6, 7, 8, 9], the output should be 1 2 4 7 5 3 6 8 9.
Q9. Allocate Books Problem Statement
Given an array of integers arr
, where arr[i]
represents the number of pages in the i-th
book, and an integer m
representing the number of students, allocate all the books in suc...read more
Allocate books to students in a way that minimizes the maximum number of pages assigned to a student.
Iterate through all possible allocations of books to students.
Calculate the maximum number of pages assigned to a student for each allocation.
Return the minimum of these maximums as the result.
Q10. Matrix Transpose Problem Statement
Given a matrix MAT
, your task is to return the transpose of the matrix. The transpose of a matrix is obtained by converting rows into columns and vice versa. Specifically, the...read more
Transpose a given matrix by switching rows and columns.
Iterate through the matrix and swap elements at [i][j] with [j][i].
Create a new matrix to store the transposed values.
Ensure the dimensions of the transposed matrix are reversed from the original matrix.
Q11. Reverse Linked List Problem Statement
Given a singly linked list of integers, return the head of the reversed linked list.
Example:
Initial linked list: 1 -> 2 -> 3 -> 4 -> NULL
Reversed linked list: 4 -> 3 -> 2...read more
Reverse a singly linked list of integers and return the head of the reversed linked list.
Iterate through the linked list and reverse the pointers to point to the previous node instead of the next node.
Use three pointers - prev, current, and next to reverse the linked list in O(N) time and O(1) space complexity.
Update the head of the reversed linked list as the last node encountered during the reversal process.
Q12. A pharmaceutical company wants to sell a pill for diabetic patients in India. Estimate the market of the pill.
The market for the diabetic pill in India needs to be estimated for a pharmaceutical company.
Consider the prevalence of diabetes in India
Analyze the current market for diabetic medications
Evaluate the potential demand for the pill based on pricing and effectiveness
Assess the competition and market share of existing diabetic pills
Consider the accessibility and affordability of the pill for the target population
Q13. Sort 0 1 2 Problem Statement
Given an integer array arr
of size 'N' containing only 0s, 1s, and 2s, write an algorithm to sort the array.
Input:
The first line contains an integer 'T' representing the number of...read more
Sort an array of 0s, 1s, and 2s in linear time complexity.
Use three pointers to keep track of 0s, 1s, and 2s while traversing the array.
Swap elements based on the values encountered to sort the array in-place.
Time complexity should be O(N) and space complexity should be O(1).
Q14. Cutting a Cake into 8 pieces with minimum moves
Cut the cake in half, stack the halves, cut in half again, stack the quarters, cut in half again.
Cut the cake in half horizontally
Stack the two halves on top of each other
Cut the cake in half vertically
Stack the four quarters on top of each other
Cut the cake in half horizontally again
Stack the two halves on top of each other again
Cut the cake in half vertically again
Q15. Case Study: Why a drug was suddenly not doing well when compared to its competitors? Three calculations on sales force optimization. (Case Type: Quantitative and Qualitative Analysis including precise calculati...
read moreThe number of pizzas sold in Pune in one day varies depending on factors like day of the week, weather, events, etc.
The number of pizzas sold in Pune can range from hundreds to thousands in a day.
Factors like day of the week (weekend vs weekday), weather (rainy vs sunny), events (festivals, holidays) can impact the sales.
Popular pizza outlets in Pune like Domino's, Pizza Hut, etc. contribute to the overall sales.
Data from previous sales records, market research, and customer ...read more
Q17. What are some of the window functions and their use?
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
Some common window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.
They are used to calculate running totals, moving averages, and cumulative sums.
Window functions require an OVER clause to define the window of rows that the function will operate on.
Q18. How many traffic lights are there in New Delhi (Guesstimate)
There are approximately 1,000 traffic lights in New Delhi.
New Delhi is a large metropolitan city with heavy traffic, so there are likely many traffic lights.
The number of traffic lights can vary based on the size of the city and the traffic flow.
An estimate of around 1,000 traffic lights is reasonable for a city like New Delhi.
Q19. A sales force optimization problem where I had to distribute X no. of available sales reps for selling two refrigerator brands. The diminishing rate of the marginal benefit with increase in sales force size of...
read moreOptimizing sales force distribution for two refrigerator brands with different diminishing marginal benefit rates.
Consider the diminishing marginal benefit rate for each brand when allocating sales reps.
Allocate more sales reps to the brand with a higher diminishing marginal benefit rate.
Regularly analyze sales data to adjust the distribution of sales reps based on performance.
Utilize sales forecasting to predict demand and allocate sales reps accordingly.
Q20. how to manage a conflict in team
Managing conflicts in a team involves effective communication, active listening, finding common ground, and seeking a win-win solution.
Encourage open communication to address the issue
Listen to all parties involved to understand their perspectives
Identify common goals and areas of agreement
Work together to find a mutually beneficial solution
Seek mediation or involve a neutral third party if necessary
Q21. 4. What should be ensured to maintain for Knowledge Transfer of project/jobs developed
To maintain knowledge transfer of project/jobs developed, ensure documentation, training, and continuous communication.
Document all project/job details, processes, and procedures.
Provide training sessions to transfer knowledge and skills.
Encourage continuous communication and collaboration among team members.
Establish a knowledge sharing platform or repository.
Conduct regular knowledge transfer meetings or workshops.
Assign mentors or experienced team members to guide and supp...read more
Q22. Guesstimates on how to calculate the number of books sold
To calculate the number of books sold, estimate the total population, percentage of people who read books, average number of books read per person, and frequency of book purchases.
Estimate the total population in the target market
Determine the percentage of people who read books
Calculate the average number of books read per person
Consider the frequency of book purchases per year
Multiply these factors to estimate the number of books sold
Q23. Plot a graph of |x| , |x|+1, x + |x|, etc.
The graph consists of multiple linear segments with different slopes.
The graph of |x| is a V-shaped graph with a slope of -1 for x < 0 and a slope of 1 for x > 0.
The graph of |x|+1 is the graph of |x| shifted upwards by 1 unit.
The graph of x + |x| is a piecewise linear graph with a slope of 2 for x > 0 and a slope of 0 for x < 0.
Q24. find 3rd highest score in each of the subject
To find the 3rd highest score in each subject
Sort the scores in each subject in descending order
Get the 3rd element in the sorted array for each subject
Repeat for each subject
Q25. SQL: Write a sproc logic to upsert data into a table.
A stored procedure logic to insert or update data in a table.
Use MERGE statement to perform upsert operation in SQL.
Check if the record exists in the table based on a unique key.
If record exists, update it. If not, insert a new record.
Q26. Explain your BTP in layman terms and give me some examples where this could be used
BTP is a technology that uses biometric data to authenticate and verify identity.
BTP stands for Biometric Technology Platform
Examples include using fingerprints or facial recognition to unlock a phone or access a secure building
BTP can also be used in healthcare to verify patient identity and access medical records
BTP is becoming more common in banking and financial services for secure transactions
BTP can improve security and reduce fraud by ensuring only authorized individua...read more
Q27. how to copy only contents of table in sql
Use SELECT INTO statement to copy contents of a table in SQL.
Use SELECT INTO statement to copy contents of a table into a new table.
Specify the columns you want to copy in the SELECT statement.
Ensure the new table has the same structure as the original table.
Q28. How many squares are there in a chess board?
There are 204 squares in a chess board.
The chess board has 64 small squares (8x8 grid)
In addition to the small squares, there are also larger squares formed by combining smaller squares (1x1, 2x2, 3x3, ... 8x8)
The total number of squares on a chess board is the sum of all these small and large squares
Q29. Guesstimate- estimate the number of urinals in ZS office
I would estimate there are around 20 urinals in the ZS office.
Consider the size of the office building and the typical ratio of urinals to toilets in commercial spaces.
Take into account the number of employees and visitors who would use the restroom facilities.
If possible, try to gather information on the floor plan or layout of the office to make a more accurate estimate.
Q30. Estimate the number of traffic lights in
Estimating the number of traffic lights in a city based on population, road density, and traffic flow.
Consider the population of the city as a factor in determining the number of traffic lights.
Road density and traffic flow patterns can also influence the placement of traffic lights.
Consulting city planning documents or traffic engineering studies may provide more accurate data.
Using satellite imagery or mapping tools to visually estimate the number of intersections with traf...read more
Q31. Tell me the overall plan for Informatica Installation and Upgrade
The overall plan for Informatica Installation and Upgrade involves several steps.
Assess the current system and determine the appropriate version to upgrade to
Ensure all prerequisites are met, including hardware and software requirements
Back up all data and configurations before beginning the installation or upgrade process
Install or upgrade the Informatica software
Configure the system and test functionality
Migrate data and configurations from the previous version if necessary...read more
Q32. How would you remove waiting lines in airport?
Implementing efficient check-in processes, increasing staff and resources, utilizing technology, and optimizing security procedures.
Implement self-service check-in kiosks to reduce the number of passengers waiting in line for manual check-in.
Increase the number of staff members at check-in counters to expedite the process.
Utilize advanced technology such as biometric identification for faster and more secure passenger verification.
Optimize security procedures to minimize the ...read more
Q33. What is the total power requirement of India?
The total power requirement of India is approximately 200,000 MW.
India's power demand is growing at a rate of 5-6% annually
As of 2021, India's installed power capacity is around 383 GW
The majority of India's power generation comes from coal-fired power plants
Renewable energy sources such as solar and wind are also being increasingly utilized
Q34. diffrence between turncat and delete
Turncoat refers to a traitor or someone who switches sides, while delete means to remove or erase something.
Turncoat is a person who changes allegiance or loyalty, often seen as a traitor.
Delete is a command used to remove or erase data or information.
Example: A turncoat politician switches parties to gain personal benefits. Deleting a file from a computer removes it permanently.
An index in SQL is a data structure that improves the speed of data retrieval operations on a database table.
Indexes are used to quickly locate data without having to search every row in a table.
They can be created on one or more columns in a table.
Examples of indexes include primary keys, unique keys, and non-unique indexes.
Q36. How many visits to the doctor may seem plausible?
The number of visits to the doctor may vary depending on the individual's health condition and medical needs.
The number of visits to the doctor can range from a few times a year for routine check-ups to multiple visits per month for individuals with chronic illnesses.
Factors such as age, overall health, and access to healthcare services can influence the frequency of doctor visits.
Some examples of plausible visit frequencies include: once a year for a healthy individual, mont...read more
Q37. What's fact, dimensions , what's stored in them
Fact and dimensions are components of a data warehouse. Facts are numerical data while dimensions are descriptive data.
Facts are quantitative data that can be measured, such as sales revenue or number of customers.
Dimensions are descriptive data that provide context for the facts, such as time, location, or product.
Facts and dimensions are stored in a data warehouse, which is a large repository of data used for analysis and reporting.
Facts are stored in fact tables, while dim...read more
Q38. How many Pizza are sold in New Delhi in a month?
It is impossible to accurately determine the exact number of pizzas sold in New Delhi in a month without specific data.
There are numerous pizza outlets in New Delhi, each with varying levels of sales.
Sales can fluctuate based on factors such as day of the week, time of year, and economic conditions.
Data on pizza sales in New Delhi would need to be obtained from individual outlets or market research reports.
Q39. 1. Different Informatica Transformations and functionality
Informatica Transformations are used to manipulate data during ETL process.
Aggregator: performs calculations on groups of data
Filter: filters rows based on a condition
Joiner: joins data from two sources based on a common key
Lookup: retrieves data from a database table or flat file
Rank: assigns a rank to each row based on a specified column
Router: routes data to different targets based on a condition
Sorter: sorts data based on one or more columns
Source Qualifier: extracts data...read more
Q40. What is the process flow of Slowly Changing Dimension Type 2 (SCD 2), and what are the associated post commands?
SCD Type 2 is used to track historical changes in data by creating new records for changes.
Identify changes in source data
Insert new record with updated data
Update end date of previous record
Add post commands like updating flags or triggers
Example: If a customer changes their address, a new record is created with the updated address while the previous record is marked as expired.
Q41. Estimate the number of pizzas sold in IIT Roorkee campus in a month
Estimating the number of pizzas sold in IIT Roorkee campus in a month.
Collect data on the number of pizza outlets in the campus
Observe the average number of pizzas sold per day at each outlet
Consider the days of the week and any special events that may affect pizza consumption
Calculate the average number of pizzas sold per day across all outlets
Multiply the average by the number of days in a month to estimate the total pizzas sold
Q42. What is list, tuple, dictionary
List, tuple, and dictionary are data structures in Python.
List: ordered, mutable, allows duplicate elements (e.g. [1, 2, 3])
Tuple: ordered, immutable, allows duplicate elements (e.g. (1, 2, 3))
Dictionary: unordered, mutable, key-value pairs (e.g. {'key1': 'value1', 'key2': 'value2'})
Q43. what is left,right,outer,inner join
Different types of SQL joins used to combine data from two or more tables.
Left join: Returns all records from the left table and the matched records from the right table.
Right join: Returns all records from the right table and the matched records from the left table.
Outer join: Returns all records when there is a match in either left or right table.
Inner join: Returns records that have matching values in both tables.
Q44. how to copy a table in sql
To copy a table in SQL, you can use the CREATE TABLE AS SELECT statement.
Use the CREATE TABLE AS SELECT statement to copy the structure and data of a table.
Specify the new table name after CREATE TABLE and the existing table name after SELECT.
Example: CREATE TABLE new_table AS SELECT * FROM existing_table;
Q45. Different types of joins in SQL
Different types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a match in both tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the left table
Full outer join: Returns rows when there is a match in either table
Q46. What are the number of cars in India?
The number of cars in India is constantly changing and difficult to determine accurately.
As of 2021, there are approximately 300 million registered vehicles in India, including cars, motorcycles, and commercial vehicles.
The number of cars in India is estimated to be around 35 million, with the majority being small hatchbacks.
The Indian automotive industry is one of the largest in the world, with several domestic and international manufacturers producing cars for the Indian ma...read more
Q47. Case Study: How to turn an ice cream chain profitable?
Q48. What are the functionalities of Qliksense and Nprinting?
Qliksense is a data visualization tool while Nprinting is a reporting tool.
Qliksense allows users to create interactive dashboards and visualizations from various data sources.
Nprinting enables users to create and distribute reports in various formats such as PDF, Excel, and PowerPoint.
Qliksense and Nprinting can be integrated to create reports from Qliksense visualizations.
Nprinting also allows for scheduling and automation of report generation and distribution.
Q49. What should be the acquisition strategy for this chain?
Q50. 2. What is SCD and types with example
SCD stands for Slowly Changing Dimensions. It is a technique used in data warehousing to track changes in data over time.
Type 1 SCD: Overwrite the old data with new data. Example: Customer address change.
Type 2 SCD: Create a new record for the change. Example: Employee promotion.
Type 3 SCD: Create a new attribute to store the change. Example: Product price change.
Type 4 SCD: Create a separate table to store the change history. Example: Customer purchase history.
Q51. Guesstimate: Estimate the number of dams in India
There are approximately 5,000 dams in India.
India has a large number of rivers and water bodies, making it necessary to build dams for various purposes such as irrigation, hydroelectric power generation, and flood control.
The Central Water Commission of India maintains a database of dams in the country, which includes both large and small dams.
As of 2021, the database lists over 5,000 dams in India, with the highest number in the state of Maharashtra.
However, the actual numbe...read more
Q52. Rank dense rank and row num difference
Dense rank assigns consecutive integers to rows with the same value, while rank leaves gaps in the ranking sequence.
Dense rank assigns the same rank to rows with the same value, with no gaps in the ranking sequence.
Rank leaves gaps in the ranking sequence for rows with the same value.
ROW_NUMBER() assigns a unique sequential integer to each row in the result set.
Q53. Guestimate on Tennis Ball in a aeroplane
It is impossible to accurately guestimate the number of tennis balls in an airplane without specific information.
The number of tennis balls in an airplane would depend on the size of the airplane, the purpose of the flight, and whether it is a commercial or private aircraft.
Factors such as the cargo capacity of the airplane, any specific events or activities taking place on the flight, and any regulations regarding carrying sports equipment would also impact the number of ten...read more
Q54. How good are you in programming languages?
I am proficient in multiple programming languages including Java, Python, and SQL.
Proficient in Java, Python, and SQL
Experience with web development languages such as HTML, CSS, and JavaScript
Familiarity with data analysis languages like R and MATLAB
Q55. What is the SQL query using PIVOT to transform the given input table into the expected output?
Using PIVOT in SQL to transform input table into expected output
Use the PIVOT keyword followed by the aggregation function and column to pivot on
Specify the values to pivot on as columns in the output table
Include the FOR clause to specify the values to pivot on
Example: SELECT * FROM input_table PIVOT (SUM(value) FOR category IN ('A', 'B', 'C')) AS output_table
Q56. Use case to design the database for startup and increase the revenue what approach
Design a database for a startup to increase revenue.
Identify key business processes and data requirements
Design a relational database schema to store the necessary data
Optimize the database structure for efficient querying and data retrieval
Implement data validation and integrity constraints
Consider scalability and future growth
Leverage data analytics and business intelligence tools for revenue optimization
Q57. Quantity of cement used in this building (Civil Engg.)
The quantity of cement used in a building is determined by the size and type of the building, as well as the construction method and design.
The quantity of cement used in a building depends on factors such as the size and type of the building.
The construction method and design also play a role in determining the quantity of cement required.
Different types of buildings, such as residential, commercial, or industrial, have varying cement requirements.
The quantity of cement can ...read more
Q58. Pyspark how to read files. Write code to read csv file
Using PySpark to read CSV files involves creating a SparkSession and using the read method.
Create a SparkSession object
Use the read method of SparkSession to read the CSV file
Specify the file path and format when reading the CSV file
Q59. 3. Difference between dynamic and status lookup
Dynamic lookup is done at runtime while status lookup is done at design time.
Dynamic lookup is used when the lookup values are not known at design time.
Status lookup is used when the lookup values are known at design time.
Dynamic lookup requires more processing power as it is done at runtime.
Status lookup is faster as it is done at design time.
Example of dynamic lookup: retrieving a list of available payment methods from a database.
Example of status lookup: selecting a status...read more
Q60. What are the projects you've done on SQL?
I have worked on various SQL projects including database design, optimization, and reporting.
Designed and implemented a database for a retail company to track inventory and sales
Optimized SQL queries for a healthcare organization to improve performance
Created reports for a financial institution to analyze customer data
Developed a data warehouse for a telecommunications company to store and analyze call data
Q61. What all types can you create in Nprinting ?
Nprinting allows creation of various types of reports such as pixel perfect, Excel, PowerPoint, Word, and HTML.
Pixel perfect reports for precise formatting
Excel reports for data analysis
PowerPoint reports for presentations
Word reports for document creation
HTML reports for web publishing
Q62. Real Life Problem of a Restaurant
One common problem faced by restaurants is food wastage.
Overproduction of food
Spoilage of ingredients
Inaccurate forecasting of demand
Lack of proper inventory management
Inefficient kitchen processes
Customer dissatisfaction with food quality
Lack of donation or composting programs
Q63. At what locations should new parlors be opened?
Q64. Guestimate like how many rats would you fit in a room
It depends on the size of the room and the size of the rats.
The size of the room and the size of the rats are important factors to consider.
Assuming an average size of 6 inches for a rat, a 10x10 room could fit around 200 rats.
However, if the room is smaller or the rats are larger, the number could be significantly less.
It's important to also consider the health and safety risks of having a large number of rats in a confined space.
Q65. Find the no of table tennis ball present in Boeing aircraft
It is not possible to determine the exact number of table tennis balls present in a Boeing aircraft.
The number of table tennis balls present in a Boeing aircraft would depend on various factors such as the size of the aircraft, its purpose, and any specific requirements.
There is no standard or specific reason for table tennis balls to be present in a Boeing aircraft, so it is unlikely that there would be a set number across all aircraft.
It is important to consider the practic...read more
Q66. You want to race 25 horses and have only 5 tracks, how do you find the fastest 3 horses?
Q67. Number of wooden articles in college?
The number of wooden articles in college is not available.
Data on the number of wooden articles in college is not provided.
There is no information on the quantity or types of wooden articles in college.
The question does not specify the context or purpose of knowing the number of wooden articles in college.
Q68. What is the process flow for implementing an incremental load?
Incremental load process flow involves identifying new/updated data, extracting, transforming, and loading it into the target system.
Identify the source data that has changed since the last load
Extract only the new/updated data from the source system
Transform the data as needed (e.g. applying business rules, data cleansing)
Load the transformed data into the target system, either appending to existing data or updating existing records
Q69. Difference Between dimension tables and fact tables.Which one loaded firs?
Dimension tables store descriptive attributes while fact tables store quantitative data. Dimension tables are loaded first.
Dimension tables contain attributes like customer name, product category, etc.
Fact tables contain quantitative data like sales revenue, quantity sold, etc.
Dimension tables are typically loaded first as they provide context for the quantitative data in fact tables.
Q70. Guesstimate about tennisballs in a plane
The number of tennis balls in a plane can vary based on the size of the plane and its purpose.
Consider the size of the plane - larger planes may have more storage space for tennis balls
Think about the purpose of the plane - a plane used for sports events may have more tennis balls
Factor in the weight limit of the plane - too many tennis balls could exceed the weight capacity
Q71. Do you have any exposure to invoicing and collections?
Yes, I have extensive experience with invoicing and collections in my previous roles.
Managed invoicing process for multiple clients, ensuring accuracy and timeliness
Implemented collection strategies to reduce outstanding balances and improve cash flow
Utilized accounting software to track invoices and monitor collections progress
Communicated with clients regarding payment reminders and resolution of billing discrepancies
Q72. PI questions: Why ZS? What do you know about ZS?
Q73. Why ZS, swap two numbers without using extra variable
To swap two numbers without using an extra variable, you can use arithmetic operations like addition and subtraction.
Store the sum of the two numbers in one of the variables, then subtract one number from the sum to get the other number.
For example, to swap numbers a=5 and b=10: a = a + b; b = a - b; a = a - b; Now a=10 and b=5.
Q74. Estimate the number of streetlights in Roorkee
Estimating the number of streetlights in Roorkee.
Collect data on the area of Roorkee and its population density.
Research the average number of streetlights per square kilometer in similar cities.
Calculate the estimated number of streetlights based on the area and population density of Roorkee.
Consider factors like main roads, residential areas, and commercial zones that may require more streetlights.
Validate the estimate by comparing it with any available official data or con...read more
Q75. Create a function to find repeated character in string
Function to find repeated characters in a string
Create a function that takes a string as input
Iterate through the string and store each character in a hashmap
If a character is already in the hashmap, it is a repeated character
Q76. Number of chewing gums consumed in India per month
There is no reliable data available on the number of chewing gums consumed in India per month.
There is no official record of chewing gum consumption in India.
The consumption of chewing gum varies widely across different regions and demographics.
Factors such as availability, affordability, and cultural preferences can influence chewing gum consumption.
Some estimates suggest that the chewing gum market in India is growing rapidly, but exact consumption figures are unknown.
Q77. Alignment with company policies
I ensure alignment with company policies by staying updated on policies, seeking clarification when needed, and consistently following guidelines.
Regularly review company policies and procedures
Seek clarification from supervisors or HR if unsure about policies
Consistently adhere to guidelines in daily work tasks
Participate in training sessions on company policies
Q78. One gess estimates to know about the number of iPhone users in a city.
To estimate the number of iPhone users in a city, one can use a combination of market research data, mobile network data, and surveys.
Utilize market research data on smartphone market share to estimate the percentage of iPhone users in the city.
Analyze mobile network data to determine the number of iPhone devices connected to the network in the city.
Conduct surveys or interviews to gather information on iPhone ownership among residents.
Consider factors such as income levels, ...read more
Q79. Choose between 2 credit cards with different data
I would choose the credit card with lower interest rate and higher rewards.
Compare the interest rates of both credit cards
Check the rewards program of both credit cards
Consider any additional fees or benefits of each card
Choose the card that best fits your spending habits and financial goals
Q80. Specific examples of how I solved such problems?
I have solved problems by analyzing business technology needs, designing solutions, and implementing them.
Analyzed a company's outdated technology infrastructure and recommended a cloud-based solution to improve efficiency and reduce costs.
Designed and implemented a custom software solution for a client to streamline their inventory management process, resulting in a 30% reduction in errors.
Resolved a complex integration issue between two software systems by conducting thorou...read more
Q81. How many cups of tea are sold in in a day?
It is impossible to accurately determine the exact number of cups of tea sold in a city in a day without specific data.
The number of cups of tea sold in a city can vary greatly depending on factors such as population size, weather, cultural preferences, and the number of tea establishments.
To estimate the number of cups sold, one would need data on the total population of the city, the average consumption of tea per person, the number of tea shops or cafes in the city, and an...read more
Q82. What are the steps involved in query optimization?
Query optimization involves steps to improve the performance of database queries.
Identify slow queries using tools like query logs or profiling.
Analyze query execution plans to understand how queries are being processed.
Optimize queries by adding indexes, rewriting queries, or restructuring data.
Consider factors like data distribution, join types, and query complexity.
Test and benchmark optimized queries to ensure performance improvements.
Q83. Create a marketing strategy to sell a newly acquired drug by company ABC
Develop a marketing strategy for a newly acquired drug by company ABC.
Identify target audience and their needs
Create a brand name and logo
Develop a strong online presence through social media and website
Partner with healthcare providers and pharmacies
Offer discounts and promotions to increase sales
Conduct clinical trials and publish results to build credibility
Attend medical conferences and events to showcase the drug
Provide educational materials to healthcare professionals a...read more
Q84. What are the various forecasting techniques?
Q85. What do you understand by Revenue Recognition?
Revenue recognition is the process of recording revenue in the financial statements when it is earned, regardless of when the payment is received.
Revenue recognition is a key accounting principle that determines when revenue should be recorded in the financial statements.
Revenue is typically recognized when it is earned, meaning when goods or services are delivered or performed.
The timing of revenue recognition can vary depending on the type of industry and the specific terms...read more
Q86. What are the different methods of Pricing?
Different methods of pricing include cost-plus pricing, value-based pricing, competitive pricing, and dynamic pricing.
Cost-plus pricing involves adding a markup to the cost of production to determine the selling price.
Value-based pricing sets prices based on the perceived value to the customer rather than the cost of production.
Competitive pricing involves setting prices based on what competitors are charging for similar products or services.
Dynamic pricing adjusts prices in ...read more
Q87. What all programming languages you are good with?
I am proficient in Java, Python, and SQL.
Java
Python
SQL
Q88. How many traffic lights in Pune?
It is impossible to accurately determine the exact number of traffic lights in Pune without access to official data.
The number of traffic lights in a city can vary based on factors such as population density, road infrastructure, and traffic flow.
One would need access to official records or conduct a comprehensive survey to determine the exact number of traffic lights in Pune.
Estimates suggest that Pune has hundreds of traffic lights scattered across the city to manage traffi...read more
Q89. Find middle node in a singly linked list in one traversal only
To find middle node in a singly linked list in one traversal only.
Use two pointers, one moving at twice the speed of the other
When the faster pointer reaches the end, the slower pointer will be at the middle
Handle edge cases like empty list or list with only one node
Q90. Joins SQL detail
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
Q91. Project in derail
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
Q92. How do you manage stakeholders expectations?
I manage stakeholders' expectations by setting clear goals, communicating effectively, and addressing concerns promptly.
Establish clear goals and objectives with stakeholders
Communicate regularly and effectively to keep stakeholders informed
Address any concerns or issues promptly to maintain trust and transparency
Manage expectations by setting realistic timelines and deliverables
Seek feedback from stakeholders to ensure alignment and satisfaction
Q93. How is cash recognized in a business?
Cash is recognized in a business when it is received or paid out, following the principles of accrual accounting.
Cash is recognized when it is received from customers for goods or services provided.
Cash is recognized when it is paid out for expenses incurred by the business.
Cash transactions are recorded in the cash account on the balance sheet.
Accrual accounting principles dictate that revenue is recognized when earned and expenses are recognized when incurred, regardless of...read more
Q94. Types of supervised learning problems.
Supervised learning problems involve predicting an output variable based on input data with labeled examples.
Classification: Predicting a categorical label (e.g. spam/not spam)
Regression: Predicting a continuous value (e.g. house prices)
Ranking: Predicting the order of a set of items (e.g. search engine results)
Q95. Why you chose this ML model over others
I chose this ML model because of its high accuracy and interpretability.
The chosen model has shown superior performance in cross-validation compared to other models.
The model's interpretability allows for easier understanding of feature importance and decision-making processes.
The chosen model is well-suited for the specific problem domain and dataset characteristics.
For example, I chose a Random Forest model over a Neural Network for its ability to handle noisy data and prov...read more
Q96. guestimates on no of pertol pumps
The number of petrol pumps can vary greatly depending on the location and population density of the area.
The number of petrol pumps in a city will be higher compared to a rural area.
Population density and traffic volume are key factors in determining the number of petrol pumps needed.
Economic factors such as income levels and vehicle ownership rates also play a role in estimating the number of petrol pumps.
For example, a busy metropolitan city may have hundreds of petrol pump...read more
Q97. Clinical Trials - Difference between blinded and double blinded studies
Q98. Explain tree based model and hyperparameters
Tree based models use decision trees to make predictions, with hyperparameters controlling the model's behavior.
Tree based models are a type of machine learning model that uses decision trees to make predictions.
Hyperparameters are settings that control the behavior of the model, such as the maximum depth of the tree or the minimum number of samples required to split a node.
Examples of tree based models include Random Forest, Gradient Boosting, and Decision Trees.
Q99. How will you design ingestion pipeline
Designing ingestion pipeline involves defining data sources, data processing steps, data storage, and data delivery mechanisms.
Identify data sources such as databases, APIs, files, etc.
Define data processing steps like data extraction, transformation, and loading (ETL).
Choose appropriate data storage solutions like databases, data lakes, or data warehouses.
Implement data delivery mechanisms for downstream applications or analytics tools.
Consider scalability, reliability, and ...read more
Q100. puzzle of cake cutting by 3 cuts
The puzzle involves cutting a cake into 8 equal pieces using only 3 cuts.
Make two perpendicular cuts to divide the cake into quarters
Stack the quarters on top of each other and make a horizontal cut to divide them into eighths
More about working at ZS
Top HR Questions asked in CMA CGM
Interview Process at CMA CGM
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month