Sundaram and Srinivasan Chartered Accountants Interview Questions and Answers

To debug Out of Memory Error, analyze memory usage and garbage collection algorithm of JVM.

• Analyze heap dump to identify memory leaks

• Check if JVM is running out of heap space

• Analyze garbage collection logs to identify any issues

• Tune JVM parameters to optimize memory usage

• Consider using a profiler to identify memory-intensive code

• Check for any large objects or arrays that may be causing the issue

Automated parking lot design with efficient space utilization and user-friendly interface.

• Use sensors to detect available parking spots

• Implement a central computer system to manage parking allocation

• Incorporate user-friendly interface for easy navigation and payment

• Maximize space utilization with multi-level parking and compact car storage

• Ensure safety measures are in place for pedestrians and vehicles

Design an auto-suggestion feature for a search engine.

• Implement a search algorithm that suggests relevant keywords based on user input.

• Use machine learning to improve the accuracy of suggestions over time.

• Allow users to easily select and add suggested keywords to their search query.

SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.

• SCD Type 2 maintains a separate row for each change in data, with a start and end date.

• It requires a surrogate key to uniquely identify each row.

• Informatica provides a built-in SCD Type 2 transformation to implement this technique.

• Example: tracking changes in customer addresses over time.