Tech Mahindra Interview Questions, Process, and Tips

Performance tuning is the process of optimizing software to improve its speed, efficiency, and resource utilization.

• Identifying bottlenecks and areas of inefficiency

• Optimizing algorithms and data structures

• Reducing I/O operations and network latency

• Caching frequently accessed data

• Profiling and benchmarking to measure improvements

• Tuning hardware and infrastructure

• Testing and validating changes before deployment

Difference between view and materialized view

• A view is a virtual table that does not store data, while a materialized view is a physical table that stores data

• Views are dynamically generated while materialized views are precomputed and stored

• Materialized views are faster for read-heavy workloads but slower for write-heavy workloads

• Materialized views need to be refreshed periodically to ensure data consistency

Design patterns are reusable solutions to common software design problems.

• Design patterns provide a common language for developers to communicate about solutions to common problems.

• They can improve the quality, maintainability, and scalability of software.

• Examples include the Singleton pattern, Factory pattern, and Observer pattern.

The N-Queen problem is to place N chess queens on an NxN board so that no two queens threaten each other.

• Backtracking is a common algorithmic technique used to solve the N-Queen problem.

• The algorithm tries to place a queen in each row of the board, and backtracks if it cannot find a valid position.

• The solution can be optimized by using bit manipulation to check for conflicts between queens.

• The time complexity of the al...read more