10+ Technical Analyst Interview Questions and Answers for Freshers

Flatten array of objects to map with minimum price for each model

• Iterate through the array and create a map with model as key and minimum price as value

• If model already exists in map, update the value with minimum price

• Return the map as the output

Use SQL query with OFFSET and LIMIT to find 10 max salaries from employee table in PostgreSQL.

• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 10 to get only the top 10 salaries

• Use OFFSET 0 to start from the beginning of the sorted list

Find 4 non-repeating characters in the given string.

• Create a hashmap to store character frequencies

• Iterate through the string and count the occurrences of each character

• Return the first 4 characters with frequency 1 as non-repeating characters

Use a thread pool executor to execute 3 methods in parallel and wait for all 3 to complete.

• Create a thread pool executor with a fixed number of threads.

• Submit the 3 methods as tasks to the executor using the `submit()` method.

• Use the `invokeAll()` method to wait for all tasks to complete.

• Handle any exceptions thrown by the tasks.

• Example: ThreadPoolExecutor executor = new ThreadPoolExecutor(3, 3, 0L, TimeUnit.MILLISECONDS, new LinkedBlockingQueue<>());

• Example: Future task1 = e...read more

It is not recommended to share documents before joining date.

• It is not common practice to share documents before joining date as they may contain sensitive information.

• Sharing documents before joining date may violate company policies or confidentiality agreements.

• Wait until your official start date to share any necessary documents with your new employer.

To find the 10th highest salary for a given employee class.

• Sort the salaries in descending order for the specific employee class.

• Skip duplicates and find the 10th unique salary.

• Return the 10th salary as the 10th Max. Salary.

Application is a software program designed to perform a specific task, while a package is a collection of software components.

• An application is a standalone program that can be installed and run on a computer or mobile device.

• A package is a collection of software components that are bundled together for easy installation and management.

• Applications are designed to perform specific tasks, such as word processing, gaming, or browsing the internet.

• Packages can include multiple a...read more

Lazy loading of beans in Spring Boot allows beans to be loaded only when they are needed, improving performance.

• Lazy loading can be achieved by using @Lazy annotation on bean definitions

• Lazy loading can also be configured in application.properties using spring.main.lazy-initialization=true

• Lazy loading is useful for optimizing application startup time and memory usage

splice is used to add/remove elements from an array, while slice is used to create a new array from a portion of an existing array.

• splice modifies the original array, while slice does not

• splice can add elements to an array at a specific index

• slice can extract a portion of an array without modifying the original array

• splice returns the removed elements, while slice returns the extracted elements

ABC is a term that can have different meanings depending on the context.

• ABC can refer to the alphabet's first three letters.

• In business, ABC can stand for Activity-Based Costing.

• In medicine, ABC can be an acronym for Airway, Breathing, and Circulation.

• ABC can also be a popular children's song and TV show.

To create a pointer array of strings:

• Declare a pointer array variable with the desired size

• Allocate memory for each string in the array using malloc

• Assign the memory address of each string to the corresponding array element

Code to reverse a binary search tree (BST)

• Traverse the BST in post-order

• Swap the left and right child of each node

• Return the root node of the reversed BST