Add office photos
Employer?
Claim Account for FREE

MindCraft Software

3.7
based on 198 Reviews
Filter interviews by

10+ Zomato Interview Questions and Answers

Updated 3 Oct 2024

Q1. Explain about SSL set up. What prerequisites are required to SSL configuration?

Ans.

SSL set up requires a valid SSL certificate and configuring web server settings.

  • Obtain a valid SSL certificate from a trusted Certificate Authority (CA)

  • Configure web server settings to enable SSL/TLS protocol

  • Ensure that the SSL certificate matches the domain name of the website

  • Update website URLs to use HTTPS instead of HTTP

  • Regularly renew SSL certificate to maintain security

Add your answer

Q2. What is GTT ? CURSOR VC REF_SURSOR WHAT IS DYNAMIC SQL ? DML VS DDL WHAT IS OVERLOOKING?

Ans.

GTT stands for Global Temporary Table, which is a temporary table used to store data temporarily during a session.

  • GTT is a temporary table that is created and used within a session

  • Data in GTT is visible only to the session that created it

  • GTT is automatically dropped at the end of the session or when the transaction is committed or rolled back

Add your answer

Q3. Spring and Spring Boot difference

Ans.

Spring Boot is a framework built on top of Spring, providing a more streamlined development experience.

  • Spring Boot provides auto-configuration, reducing the need for manual configuration

  • Spring Boot includes an embedded server, making it easier to deploy applications

  • Spring Boot provides a simpler project structure and faster development experience

  • Spring Boot is opinionated, providing defaults for many configuration options

  • Spring Boot is built on top of Spring, providing all th...read more

Add your answer

Q4. Exception all types of exception

Ans.

There are three types of exceptions in Java: checked, unchecked, and errors.

  • Checked exceptions are checked at compile-time, e.g. IOException

  • Unchecked exceptions are not checked at compile-time, e.g. NullPointerException

  • Errors are caused by the environment in which the application is running, e.g. OutOfMemoryError

Add your answer
Discover Zomato interview dos and don'ts from real experiences

Q5. Perform CRUD on MVC or Asp.net

Ans.

Performing CRUD on MVC or Asp.net

  • Create: Use HTTP POST method to add new data to the database.

  • Read: Use HTTP GET method to retrieve data from the database.

  • Update: Use HTTP PUT or PATCH method to modify existing data in the database.

  • Delete: Use HTTP DELETE method to remove data from the database.

Add your answer

Q6. How many API's developed on previous project?

Ans.

I developed 3 APIs on my previous project.

  • Developed 3 APIs for data retrieval, user authentication, and payment processing.

  • Used RESTful architecture for API development.

  • Integrated APIs with frontend and backend systems for seamless communication.

Add your answer
Are these interview questions helpful?

Q7. Architechture used in project

Ans.

The project uses a microservices architecture.

  • The architecture is based on the principles of microservices.

  • Each service is developed and deployed independently.

  • The services communicate with each other through APIs.

  • The architecture allows for scalability and flexibility.

  • Examples of technologies used include Docker, Kubernetes, and AWS.

Add your answer

Q8. Explain about multi instance

Ans.

Multi instance refers to the ability of a system to run multiple instances of an application or service simultaneously.

  • Multi instance allows for greater scalability and flexibility in a system.

  • It can be used to distribute workload across multiple instances, improving performance and reducing downtime.

  • Examples include running multiple instances of a web server or database server.

  • Multi instance can also be used for redundancy and failover purposes.

  • It is important to properly ma...read more

Add your answer
Share interview questions and help millions of jobseekers 🌟

Q9. OOPS concept and example

Ans.

OOPS stands for Object-Oriented Programming System. It is a programming paradigm based on the concept of objects.

  • OOPS is based on four main concepts: Encapsulation, Inheritance, Polymorphism, and Abstraction.

  • Encapsulation is the process of hiding the implementation details of an object from the outside world.

  • Inheritance is the process of creating a new class from an existing class, inheriting all the properties and methods of the parent class.

  • Polymorphism is the ability of an...read more

Add your answer

Q10. All annotations in Spring Boot

Ans.

Spring Boot has various annotations for different purposes.

  • SpringBootApplication - main class of Spring Boot application

  • RestController - marks a class as a RESTful controller

  • Autowired - injects dependencies automatically

  • RequestMapping - maps HTTP requests to handler methods

  • Value - injects values from properties file or environment variables

Add your answer

Q11. How NodeJs Works

Ans.

NodeJs is a runtime environment that allows you to run JavaScript on the server side.

  • NodeJs uses an event-driven, non-blocking I/O model which makes it lightweight and efficient.

  • It is built on the V8 JavaScript engine from Google Chrome.

  • NodeJs allows you to easily build scalable network applications.

  • It uses the CommonJS module system for organizing code.

  • NodeJs has a large ecosystem of open source libraries available through npm.

Add your answer

Q12. How Promises works

Ans.

Promises in JavaScript are objects representing the eventual completion or failure of an asynchronous operation.

  • Promises are used to handle asynchronous operations in JavaScript.

  • They can be in one of three states: pending, fulfilled, or rejected.

  • Promises can be chained using .then() method to handle success and failure.

  • Example: const promise = new Promise((resolve, reject) => { ... });

Add your answer

Q13. What is query optimization ?

Ans.

Query optimization is the process of improving the performance of a database query.

  • It involves analyzing and modifying the query to reduce the execution time and resource usage.

  • Techniques include indexing, rewriting the query, and using query hints.

  • Example: Adding an index to a frequently used column can significantly improve query performance.

  • Example: Rewriting a complex query to use simpler subqueries can also improve performance.

  • Example: Using query hints to force the data...read more

Add your answer

Q14. How many Nodes Worked on earlier project

Ans.

There were 5 nodes worked on the earlier project.

  • 5 nodes were involved in the project

  • Each node had specific tasks and responsibilities

  • Collaboration and communication among nodes were crucial for project success

Add your answer

Q15. Explain complete CICD proecess?

Ans.

CICD process involves continuous integration, continuous delivery, and continuous deployment to automate software delivery.

  • Continuous Integration (CI) - Developers regularly merge code changes into a shared repository, triggering automated builds and tests.

  • Continuous Delivery (CD) - Code changes that pass automated tests are automatically deployed to a staging environment for further testing.

  • Continuous Deployment - Code changes that pass all tests are automatically deployed t...read more

Add your answer

Q16. Explain sql joins

Ans.

SQL joins 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

  • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

  • INNER JOIN returns rows when there is at least one 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 ro...read more

Add your answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Zomato

based on 11 interviews in the last 1 year
Interview experience
3.9
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Interview Questions from Similar Companies

3.9
 • 701 Interview Questions
3.6
 • 378 Interview Questions
3.5
 • 299 Interview Questions
4.1
 • 247 Interview Questions
3.6
 • 178 Interview Questions
4.0
 • 156 Interview Questions
View all
Top MindCraft Software Interview Questions And Answers
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions
Get AmbitionBox app

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter