INFISTACK TECHNOLOGIES Software Consultant Interview Questions and Answers for Experienced

Employee model CRUD APIS USING SRPING BOOT & MYSQL

Q1. TELL ME ABOUT YOUR SELF
Add your answer
Q2. SPRING BOOT VS SPRING
Ans. 
Spring Boot is a framework that simplifies Spring development by providing pre-configured settings and dependencies.
• Spring Boot is built on top of the Spring framework.

• Spring Boot provides a standalone executable that can run the application.

• Spring Boot provides auto-configuration, which reduces the need for manual configuration.

• Spring Boot provides a wide range of starter dependencies that can be easily added to the p...read more
Answered by AI
Add your answer
Q3. JPA VS HIBERNATE WHAT IS ADVANTAGE USING JPA
Ans. 
JPA is a specification while Hibernate is an implementation of JPA. JPA provides a standard API for ORM frameworks.
• JPA is a standard API for ORM frameworks

• JPA provides a vendor-neutral interface

• JPA allows for easy switching between ORM frameworks

• Hibernate is an implementation of JPA

• Hibernate provides additional features beyond JPA
Answered by AI
Add your answer
Q4. WHTA IS MYSQL GROUP BY & DISTINCT
Ans. 
MySQL GROUP BY is used to group rows with same values. DISTINCT is used to remove duplicate values from a column.
• GROUP BY is used with aggregate functions like COUNT, SUM, AVG, etc.

• DISTINCT is used to retrieve unique values from a column.

• GROUP BY and DISTINCT can be used together to group and retrieve unique values.

• Example: SELECT COUNT(*) FROM table_name GROUP BY column_name;

• Example: SELECT DISTINCT column_name FROM t
Answered by AI
Add your answer
Q5. WHAT ARE SCOPES ARE AVAILABLE IN SPRING
Ans. 
Spring has four scopes: Singleton, Prototype, Request, and Session.
• Singleton scope creates a single instance of a bean.

• Prototype scope creates a new instance of a bean every time it is requested.

• Request scope creates a new instance of a bean for each HTTP request.

• Session scope creates a new instance of a bean for each HTTP session.
Answered by AI
Add your answer