EasyRewardz Software Services Interview Questions and Answers

Problems on dsa, SQL and development

Q1. What's Lock keyword
Ans. 
Lock keyword is used in C# to synchronize access to a shared resource by allowing only one thread to enter a critical section at a time.
• Used to prevent multiple threads from accessing a shared resource simultaneously

• Helps in avoiding race conditions and maintaining data integrity

• Can be used with Monitor class or lock statement
Answered by AI
Add your answer
Q2. What's Yield keywords
Ans. 
Yield keyword is used in C# to return a sequence of values one at a time.
• Yield keyword is used in iterator methods to return each element one by one.

• It allows the method to return multiple values without needing to store them all in memory.

• Yield return statement is used to return a value from the iterator method.
Answered by AI
Add your answer

Q1. Difference between inheritance and composition
Ans. 
Inheritance is an 'is-a' relationship where a class inherits properties and behaviors from another class. Composition is a 'has-a' relationship where a class contains an instance of another class.
• Inheritance involves creating a new class by using existing class's properties and behaviors.

• Composition involves creating a class that contains an instance of another class.

• Inheritance promotes code reusability and is used fo...read more
Answered by AI
Add your answer

Q1. Tell me about yourself?
Add your answer

Business use case and detailed approach to solve that problem statement. Interviewer was looking for approach which you are taking to solve this business problem.

Business case study where they provided problem statement around apparel industry and their how can we use loyality program to benefit that business.

Q1. SQL, Excel, PPT Presentation
Add your answer

Q1. SQL, python questions asked in interview
Add your answer
Q2. Pyspark question asked based on data
Add your answer
Q3. Database related
Add your answer
Q4. Script to insert data in table
Ans. 
A script to insert data into a SQL table using INSERT statements.
• Use the INSERT INTO statement to add data to a table.

• Specify the table name and the columns to insert data into.

• Provide the values to be inserted in the same order as the columns.

• Example: INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'HR');

• You can insert multiple rows in a single query: INSERT INTO employees (name, age) VALUES ('Al...read more
Answered by AI
Add your answer
Q5. Joins, sql queries
Add your answer