Tech Mahindra Application Support Engineer Interview Questions and Answers

An Application Support Engineer ensures software applications run smoothly, providing technical support and troubleshooting issues.

• Technical Support: Provide assistance to users experiencing issues with applications, such as resolving login problems or application errors.

• Incident Management: Monitor and manage incidents, ensuring timely resolution and communication with stakeholders, like escalating issues to developme...read more

SQL is a database language used to manage data. Unix is an operating system used for servers and workstations.

• SQL is used to create, modify, and query databases.

• Unix is a command-line interface used for file management, process control, and networking.

• SQL can be used with various database management systems like MySQL, Oracle, and SQL Server.

• Unix commands include ls, cd, grep, and chmod.

• SQL and Unix are commonly used i...read more

I will investigate the root cause of the slow performance and take appropriate actions.

• Check server resources usage

• Analyze application logs

• Identify bottleneck areas

• Optimize database queries

• Implement caching mechanisms

• Upgrade hardware or software if necessary

Common SQL commands for data manipulation and retrieval

• SELECT - retrieve data from a table

• INSERT - insert data into a table

• UPDATE - update existing data in a table

• DELETE - delete data from a table

• CREATE - create a new table or database

• ALTER - modify the structure of a table

• DROP - delete a table or database

• JOIN - combine data from multiple tables

• GROUP BY - group data based on a specific column

• ORDER BY - sort data based ...read more