Tech Mahindra Associate Consultant Interview Questions and Answers

Triggers are database objects that automatically execute in response to certain events or changes in data.

• Triggers are used to enforce business rules or data integrity.

• They can be used to audit changes to data.

• Triggers can be set to execute before or after an event, such as an insert, update, or delete operation.

• They can be defined on tables, views, or schemas.

• Examples of triggers include sending an email notification ...read more

Depreciation is necessary to allocate the cost of an asset over its useful life.

• Depreciation helps in matching the cost of an asset with the revenue it generates.

• It allows for the recognition of the wear and tear, obsolescence, and loss of value of assets over time.

• Depreciation expense reduces taxable income, resulting in tax savings for companies.

• It helps in determining the true profitability and financial position of...read more

Switch case is used for multiple conditions while if else is for binary conditions. Sorting can be done using various algorithms.

• Switch case is faster than if else for multiple conditions

• If else is more readable for binary conditions

• Sorting can be done using bubble sort, insertion sort, quick sort, etc.

• Example code for bubble sort: for(i=0;iarr[j+1]){swap(&arr[j],&arr[j+1]);}}}

Difference between compiler and interpreter with a coding challenge

• Compiler translates the entire code into machine language before execution while interpreter translates line by line during execution

• Compiler generates an executable file while interpreter does not

• Compiler is faster but debugging is harder while interpreter is slower but debugging is easier

• Coding challenge: Write a program to find the sum of two numbers