People Source Consulting Interview Questions and Answers

Q1. Sql, python, tableau are important topics
Add your answer
Q2. Prepare windows function in sql
Ans. 
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()
Answered by AI
Add your answer

Q1. Why do you think you would be a good fit at our company
Add your answer
Q2. Lets say your boss is asking you to lie for the benefit of the company will you do it
Add your answer

Q1. This round was focussed on capturing details of Functional Knowledge
Add your answer

Q1. Focussed on future aspirations and checking how is this aligned with Organisation growth plan
Add your answer

Q1. Difference between functions and stored procedure in SQL.
Ans. 
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
Answered by AI
Add your answer
Q2. Difference between abstract class and Interface in C#
Ans. 
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
Answered by AI
Add your answer

Q1. Do you have any experience into recruitment?
Add your answer

How can you manage daily travelling?

Q1. Selenium WebDriver framework
Add your answer
Q2. Java program
Add your answer

Q1. String immutable question in java
Add your answer
Q2. Annotations in Spring boot
Ans. 
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
Answered by AI
Add your answer