Prime View India Infin Interview Questions and Answers

Annotations in Spring Boot are used to simplify the configuration and development of applications.

• Annotations are used to provide metadata about the application's components

• They help in reducing the amount of configuration required

• Examples include @RestController, @Autowired, @RequestMapping

Functions return a single value while stored procedures can perform multiple operations and return multiple values.

• Functions return a single value while stored procedures can return multiple values.

• Functions are used for computations and return values, while stored procedures are used for executing a series of statements.

• Functions can be called from within SQL statements, while stored procedures are called using the EX...read more

Abstract class can have implementation details, while interface only contains method signatures.

• Abstract class can have constructors, fields, and methods with implementation details, while interface can only have method signatures.

• A class can inherit from only one abstract class, but can implement multiple interfaces.

• Abstract classes are used when some common functionality needs to be shared among multiple classes, whi...read more

Windows function in SQL is used to perform calculations across a set of rows that are related to the current row.

• Windows functions are used to calculate values based on a group of rows

• They are used with the OVER clause

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), SUM(), AVG(), MIN(), MAX()

Coalesce reduces the number of partitions in a DataFrame, while repartition increases the number of partitions.

• Coalesce is used to reduce the number of partitions in a DataFrame without shuffling the data

• Repartition is used to increase the number of partitions in a DataFrame and can involve shuffling the data

• Coalesce is more efficient than repartition when reducing partitions as it avoids shuffling