Tech Mahindra Team Lead Operations Interview Questions, Process, and Tips

Trunc is a DDL command used to delete all rows from a table, while delete is a DML command used to remove specific rows.

• Trunc is faster than delete as it does not log individual row deletions.

• Trunc resets the identity seed of the table, while delete does not.

• Trunc cannot be rolled back, while delete can be rolled back using a transaction.

• Trunc is used to quickly remove all rows from a table, while delete is used to rem

Cursors are used in databases to retrieve and manipulate data row by row.

• Cursors allow for sequential processing of query results.

• They can be used to update or delete specific rows in a result set.

• Cursors can be used in stored procedures to iterate through a result set.

• Example: DECLARE cursor_name CURSOR FOR SELECT column1, column2 FROM table_name;

Debugging of code involves identifying and fixing errors in the code to ensure it runs correctly.

• Understand the code and its expected behavior

• Use debugging tools like breakpoints, print statements, and logging

• Isolate the issue by narrowing down the scope of the problem

• Test different scenarios to reproduce the error

• Fix the error by making necessary changes to the code

• Verify the fix by testing the code again

Attrition is the rate of employee turnover in an organization.

• Attrition is calculated by dividing the number of employees who left the organization by the average number of employees in the organization during a specific period of time.

• It is an important metric for HR and operations teams to track as high attrition rates can indicate issues with employee satisfaction, company culture, or management.

• For example, if a co...read more