Excellanto Programmer Analyst Trainee Interview Questions and Answers

Swap two numbers with and without temporary variable

• Without temporary variable: Use addition and subtraction

• With temporary variable: Use a third variable to store the value of one of the numbers

• Example without temporary variable: a=5, b=7; a=a+b; b=a-b; a=a-b;

• Example with temporary variable: a=5, b=7; temp=a; a=b; b=temp;

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

Second level cache is a caching mechanism used to improve performance by storing frequently accessed data in memory.

• Second level cache is implemented at the application level and can be configured using frameworks like Hibernate.

• To optimize SQL queries, one can use indexes, avoid using SELECT *, and use JOINs instead of subqueries.

• SOLID principles are a set of design principles for writing maintainable and scalable cod...read more

To deploy an application in AWS, you need to create an EC2 instance, configure security groups, install necessary software, and upload your application code.

• Create an EC2 instance in the desired region and select the appropriate instance type

• Configure security groups to allow traffic to and from the instance

• Install necessary software and dependencies on the instance

• Upload your application code to the instance

• Start the ...read more