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

You can find the heavy ball among 8 balls using a balance in just 2 weighings.

• Divide the 8 balls into 3 groups: 3, 3, and 2.

• Weigh the first two groups (3 vs 3).

• If they balance, the heavy ball is in the group of 2.

• If one group is heavier, take 2 balls from that group and weigh them.

• The heavier ball will be identified in the second weighing.

The student with the second highest score is Adil, who scored 70, following Vikas with 99 and Goutham with 90.

• Score Ranking: The scores are ranked as follows: Vikas (99), Goutham (90), Adil (70), and Sam (10).

• Identifying Second Highest: To find the second highest, we can sort the scores and select the second entry.

• Data Structure: The data is stored in a dictionary format, which allows for easy access to scores by student names.

• Example: If we had scores like {'A': 50, 'B': 80,...read more

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

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 ...read more

The Two Pill Blind Puzzle involves a strategic approach to determine which pill is safe to take.

• You have two pills: one is safe, the other is poisonous.

• You can ask one question to one of two blindfolded individuals.

• The individuals know which pill is safe but will answer truthfully or falsely.

• Ask one person what the other would say if you asked them which pill is safe.

• If they point to the safe pill, take it; if they point to the poisonous one, take the other.

The @async annotation is used to make an API asynchronous.

• Add the @async annotation to the method declaration

• Use CompletableFuture or a similar mechanism to handle the asynchronous execution

• Ensure the API returns a CompletableFuture or a similar asynchronous result

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.

I prioritize tasks by assessing urgency, impact, and deadlines, ensuring efficient workflow and timely project completion.

• Assess urgency: I categorize tasks based on deadlines, focusing on those that are time-sensitive first.

• Evaluate impact: I consider the potential impact of each task on overall project goals, prioritizing high-impact tasks.

• Use a task management tool: I utilize tools like Trello or Asana to visualize tasks and their priorities.

• Break down larger tasks: For co...read more

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

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.

DHCP is used to automatically assign IP addresses to devices on a network.

• DHCP is used in both small and large networks.

• It is commonly used in home networks to assign IP addresses to devices like computers, smartphones, and smart TVs.

• DHCP is also used in enterprise networks to manage IP address allocation for a large number of devices.

• It simplifies network administration by eliminating the need for manual IP address configuration.

• DHCP is used in various environments such as o...read more

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