MindCraft Software
10+ Zomato Interview Questions and Answers
Q1. Explain about SSL set up. What prerequisites are required to SSL configuration?
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
Q2. What is GTT ? CURSOR VC REF_SURSOR WHAT IS DYNAMIC SQL ? DML VS DDL WHAT IS OVERLOOKING?
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
Q3. Spring and Spring Boot difference
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
Q4. Exception all types of exception
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
Q5. Perform CRUD on MVC or Asp.net
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.
Q6. How many API's developed on previous project?
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.
Q7. Architechture used in project
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.
Q8. Explain about multi instance
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
Q9. OOPS concept and example
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
Q10. All annotations in Spring Boot
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
Q11. How NodeJs Works
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.
Q12. How Promises works
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) => { ... });
Q13. What is query optimization ?
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
Q14. How many Nodes Worked on earlier project
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
Q15. Explain complete CICD proecess?
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
Q16. Explain sql joins
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
Interview Process at Zomato
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month