Zepto Interview Questions, Process, and Tips

Q1. Questions on Past Project
Add your answer
Q2. SQL Dense Rank - also having the option to do in Pandas
Add your answer
Q3. Pandas groupby on a dataset given - required to calculate group wise yoy rate of a column
Add your answer

Q1. Past project ( which he chose , he chose my very first project , which I had forgotten) so ended up screwing it
Add your answer
Q2. SQL / Pyspark question - difficult question
Add your answer

Q1. Write negative testcases for cart value not greater equal to 1000
Ans. 
Negative testcases for cart value less than 1000
• Add a product with a price less than 1000 to the cart

• Remove all products from the cart and check if the total value is less than 1000

• Add multiple products to the cart but ensure the total value is less than 1000
Answered by AI
Add your answer
Q2. Write HTTP status codes
Ans. 
HTTP status codes are standardized codes used to indicate the result of a HTTP request.
• 1. 2xx - Success: Request was successful (e.g. 200 OK)

• 2. 3xx - Redirection: Further action needs to be taken (e.g. 301 Moved Permanently)

• 3. 4xx - Client Error: Request cannot be fulfilled (e.g. 404 Not Found)

• 4. 5xx - Server Error: Server failed to fulfill a valid request (e.g. 500 Internal Server Error)
Answered by AI
Add your answer
Q3. How can you check backward compatibility in API (if BE changes are deployed on PROD)
Ans. 
To check backward compatibility in API after BE changes are deployed on PROD, perform regression testing on existing functionalities.
• Perform regression testing on existing API functionalities to ensure they still work as expected after BE changes

• Check if any existing API endpoints have been deprecated or modified due to BE changes

• Verify if any new API endpoints have been added and test their functionality

• Ensure that th...read more
Answered by AI
View 1 more answer
Q4. GET, POST, PUT, PATCH difference
Ans. 
GET retrieves data, POST submits data, PUT updates data, PATCH partially updates data
• GET is used to retrieve data from a server

• POST is used to submit data to a server

• PUT is used to update existing data on a server

• PATCH is used to partially update existing data on a server
Answered by AI
Add your answer
Q5. How to test netowork latency while testing mobile apps
Ans. 
Use network monitoring tools and simulate different network conditions to test network latency in mobile apps.
• Use network monitoring tools like Wireshark or Charles Proxy to analyze network traffic and identify latency issues.

• Simulate different network conditions (3G, 4G, WiFi, etc.) using tools like Network Link Conditioner on iOS or Android Emulator on Android.

• Measure latency by sending requests to a server and calcu...read more
Answered by AI
Add your answer
Q6. In which method data is more secure GET or POST?
Ans. 
POST method is more secure than GET method for transmitting sensitive data.
• POST method sends data in the request body, making it more secure as the data is not visible in the URL.

• GET method sends data in the URL, which can be visible in browser history, server logs, and can be easily intercepted.

• POST method is recommended for transmitting sensitive information like passwords, credit card details, etc.

• GET method is comm...read more
Answered by AI
Add your answer
Q7. SQL: UPDATE the name of EMPLOYEE having 3rd high salary
Ans. 
Update the name of employee with 3rd highest salary in SQL
• Use a subquery to find the 3rd highest salary

• Join the subquery with the EMPLOYEE table on salary to get the employee name

• Use the UPDATE statement to update the name of the employee
Answered by AI
Add your answer
Q8. Scenario based question
Add your answer
Q9. What is RACE condition
Ans. 
A RACE condition is a situation in which the outcome of a program depends on the order of execution of its components.
• Occurs in concurrent programming when multiple threads access shared data and the outcome depends on the order of execution

• Can lead to unpredictable behavior and bugs in the program

• Example: Two threads trying to increment the same variable simultaneously can result in incorrect values due to race condit
Answered by AI
Add your answer

Q1. SQK Questions joins
Add your answer

Case study on planning

Case study on planning

Q1. General questions
Add your answer

Q1. What is the implementation of an accordion feature using vanilla JavaScript?
Ans. 
Implementing an accordion feature using vanilla JavaScript
• Create HTML structure with headings and content sections

• Add event listener to headings to toggle visibility of content

• Use CSS to style accordion for better user experience
Answered by AI
Add your answer
Q2. What is a polyfill for Promise.all, and how does it work?
Ans. 
A polyfill for Promise.all is a code snippet that provides the functionality of Promise.all for browsers that do not support it natively.
• Polyfill for Promise.all can be implemented using a combination of Promise, Array.prototype.map, and Array.prototype.reduce.

• It allows you to wait for multiple promises to resolve and then returns an array of their results.

• Example: const promise1 = Promise.resolve(3); const promise2 = ...read more
Answered by AI
Add your answer

Q1. Tell me About Yourself?
Add your answer
Q2. What is the Role of Pharmacist?
Add your answer
Q3. What is Antibiotic and Antibodies?
Add your answer
Q4. Metformin Used For Which Disease?
Add your answer
Q5. What is Diabetes?
Add your answer

Q1. I want g grow up my career in zepto cafe
Add your answer
Q2. This job is very convenient for me I will be available at anytime
Add your answer