20+ Ashra Consultants Private Limited Interview Questions and Answers

Given an array, find a subset that sums to a given sum K and print all triplets that sum to K.

• Use a recursive approach to find subsets that sum to K

• Use a nested loop to find triplets that sum to K

• Avoid using duplicate elements in triplets

Count occurrences of given element in a sorted array.

• Use binary search to find the first and last occurrence of the element.

• Subtract the indices to get the count of occurrences.

• Handle edge cases like element not present in array.

Given a binary tree, find the path with the largest sum of node values.

• Use depth-first search to traverse the tree and keep track of the current path sum.

• At each node, compare the current path sum with the maximum path sum seen so far.

• Return the path with the maximum sum.

• If the tree is empty, return an empty path.

Logistics industry involves the management of the flow of goods and services. It is expected to grow with the rise of e-commerce.

• Logistics industry involves transportation, warehousing, and distribution of goods and services

• It plays a crucial role in supply chain management

• The rise of e-commerce has led to an increase in demand for logistics services

• Technological advancements such as automation and artificial intelligence are transforming the industry

• Sustainability and enviro...read more

Reverse a linked list by group of given size

• Divide the linked list into groups of given size

• Reverse each group individually

• Connect the reversed groups to form the final linked list

Use a unique identifier for each item in the recycler view and send it to the backend via API calls. Optimize by batching API calls and implementing pagination.

• Assign a unique identifier to each item in the recycler view, such as an ID or position

• Send the unique identifier of the currently shown item to the backend through API calls

• Optimize by batching API calls to reduce network overhead

• Implement pagination to load data in chunks and improve performance

MVVM focuses on separation of concerns between UI, business logic, and data layers, while MVC separates application into model, view, and controller.

• MVVM stands for Model-View-ViewModel, where ViewModel acts as a mediator between View and Model.

• MVVM is commonly used in WPF and Xamarin applications.

• MVC stands for Model-View-Controller, where Controller handles user input, Model manages data, and View displays information.

• MVC is commonly used in web development frameworks like ...read more

SQL queries for Business Analyst role

• SELECT * FROM table_name;

• SELECT column_name FROM table_name WHERE condition;

• SELECT COUNT(*) FROM table_name;

• SELECT AVG(column_name) FROM table_name;

• SELECT MAX(column_name) FROM table_name;

• SELECT MIN(column_name) FROM table_name;

• SELECT column_name1, column_name2 FROM table_name1 JOIN table_name2 ON table_name1.column_name = table_name2.column_name;

• SELECT column_name1, COUNT(column_name2) FROM table_name GROUP BY column_name1;

Handled stakeholder relationships with clients, vendors, and internal teams to ensure successful project delivery.

• Managed communication and expectations with clients throughout project lifecycle

• Collaborated with vendors to ensure timely delivery of goods and services

• Worked closely with internal teams to ensure project goals were met

• Identified and addressed any potential conflicts or issues with stakeholders

• Maintained positive relationships with stakeholders to ensure future b...read more

Design a clean code structure for API call, DB update, and UI update.

• Separate concerns by creating separate classes or modules for API call, DB update, and UI update.

• Use interfaces or abstract classes to define contracts for each component.

• Implement error handling and data validation at each step.

• Consider using asynchronous programming to prevent blocking the UI thread.

• Use dependency injection to manage dependencies between components.

My future goal is to continuously improve my skills and knowledge in customer support, and eventually move up to a leadership position.

• Continuously learn and improve customer support skills

• Seek out opportunities for leadership development

• Set goals and create a plan for career advancement

• Stay up-to-date with industry trends and best practices

RecyclerView is used to display large sets of data efficiently. ItemView is used to define the layout of each item in the list.

• RecyclerView is a more advanced version of ListView and GridView

• ItemView is a layout file that defines the UI for each item in the list

• RecyclerView.Adapter is used to bind the data to the views

• RecyclerView.LayoutManager is used to define the layout of the RecyclerView

• RecyclerView.ViewHolder is used to hold the views for each item in the list

Create a timer using React

• Use useState hook to store the timer value

• Use useEffect hook to update the timer every second

• Display the timer value in the component's render method

I will send you the product quotation via email.

• Address the recipient by name and company

• Provide details of the products requested

• Include pricing and any applicable discounts

• End with a call to action for further discussion or confirmation

Create a simple timer using React

• Use state to store the timer value

• Use setInterval to update the timer every second

• Display the timer value in the component's render method

Improving customer base requires targeted marketing, exceptional customer service, and positive word-of-mouth.

• Identify target audience and tailor marketing efforts accordingly

• Provide exceptional customer service to retain existing customers and attract new ones

• Encourage positive word-of-mouth through referral programs and social media engagement

• Offer promotions and discounts to incentivize new customers to try your product/service

• Analyze customer data to understand their need...read more

High level design for a cab booking service

• Use a centralized database to store cab availability and user information

• Implement a matching algorithm to assign cabs to users based on location and availability

• Include a payment gateway for users to pay for their rides

• Develop a mobile app and web interface for users to book cabs

• Integrate GPS tracking for real-time cab location updates

Find the maximum sum path in a tree from root to leaf node.

• Start from the root node and traverse down to leaf nodes, keeping track of the sum at each node.

• At each node, compare the sum of the current path with the maximum sum found so far.

• Choose the path with the maximum sum as the final result.