Rivera Manpower Services Interview Questions and Answers

Q1. Salary Expectation
Add your answer
Q2. Work Experience
Add your answer
Q3. Relocation Plans
Add your answer

Codility Test General C# and SQL

Q1. (live coding) Create a class Employees with fields FirstName LastName, DoB, and Gender Return avg age of employees, return avg age by genders
Ans. 
Create a class Employees with fields FirstName LastName, DoB, and Gender. Return avg age of employees and avg age by genders.
• Create a class Employees with fields FirstName, LastName, DoB, and Gender

• Calculate the average age of all employees

• Calculate the average age by genders
Answered by AI
Add your answer
Q2. What design pattern you know
Ans. 
I am familiar with design patterns such as Singleton, Factory, Observer, and MVC.
• Singleton pattern ensures a class has only one instance and provides a global point of access to it.

• Factory pattern creates objects without specifying the exact class of object that will be created.

• Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and up...read more
Answered by AI
Add your answer
Q3. SOLID principles
Add your answer
Q4. How to optimize SQL Queries
Ans. 
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
• Use indexes on columns frequently used in WHERE clauses

• Minimize data retrieval by selecting only necessary columns

• Avoid unnecessary joins by using EXISTS or IN clauses instead

• Optimize query structure by using appropriate joins and subqueries
Answered by AI
Add your answer
Q5. Which type of Indexes you know
Ans. 
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
• Clustered index: Physically reorders the data in the table based on the index key.

• Non-clustered index: Contains a sorted list of references to the table data rows.

• Unique index: Ensures that no two rows have the same values in the indexed columns.

• Composite index: Index that is created on multiple columns.

• Filtered index: Index that...read more
Answered by AI
Add your answer
Q6. Have you ever read SQL Execution Plan?
Ans. 
Yes, I have read SQL Execution Plans to optimize query performance.
• I have analyzed SQL Execution Plans to identify bottlenecks in queries.

• I have used SQL Execution Plans to optimize query performance by understanding how the database engine executes queries.

• I have made query optimization recommendations based on SQL Execution Plans.

• I have experience with tools like SQL Server Management Studio to view and analyze Execu
Answered by AI
Add your answer
Q7. .NET Framework DI 3th party tools
Add your answer
Q8. Are you familiar with MSUnit, xUnit, nUnit
Add your answer
Q9. Unit Testing libraries (e.g Bogus, Moq..)
Add your answer

Q1. What questions do you have?
Add your answer
Q2. How was your interview's?
Add your answer
Q3. Why you want to change your job?
Add your answer