Tech Mahindra Technical Project Manager Interview Questions and Answers

We can achieve this by sending the data in chunks using pagination.

• Implement pagination to limit the amount of data sent per request.

• Use a cursor-based pagination approach to efficiently retrieve large amounts of data.

• Consider compressing the data to reduce the size of each chunk.

• Use HTTP range requests to retrieve specific chunks of data.

To achieve load balance and fault tolerance while deploying an application, we can use techniques like load balancing, clustering, and redundancy.

• Implement load balancing to distribute incoming traffic across multiple servers.

• Use clustering to group multiple servers together to work as a single unit.

• Ensure redundancy by having multiple instances of critical components to handle failures.

• Implement fault-tolerant mechani...read more

Shared variables are accessible by all tasks in a process, while job shared variables are only accessible by tasks in a specific job.

• Shared variables are used to share data between tasks in a process.

• Job shared variables are used to share data between tasks in a specific job.

• Shared variables can cause race conditions and should be used with caution.

• Job shared variables are useful for passing data between tasks in a job

DB activities that can be part of a transaction group

• Insertion of data into a table

• Updating data in a table

• Deletion of data from a table

• Creating or dropping a table

• Altering the structure of a table

• Executing stored procedures

• Executing functions

• Executing triggers