Datman Business Intelligence Engineer 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;

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