20+ Delhivery Interview Questions and Answers

Answering questions related to Mutual funds, depreciation, RBI, GDP and their calculation.

• Mutual fund is a type of investment where money is pooled from multiple investors and invested in various securities.

• Depreciation is the decrease in value of an asset over time due to wear and tear or obsolescence.

• RBI (Reserve Bank of India) is the central bank of India responsible for regulating the country's monetary policy and currency.

• GDP (Gross Domestic Product) is the total value o...read more

Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.

• Types of derivatives include options, futures, forwards, and swaps.

• Mutual funds are investment vehicles that pool money from multiple investors to invest in a diversified portfolio of securities.

• Common ratios used in financial analysis include price-to-earnings ratio (P/E), return on equity (ROE), and debt-to-equity ratio.

Mutual funds are investment vehicles that pool money from multiple investors to invest in a diversified portfolio of securities.

• Types of mutual funds include equity funds, debt funds, balanced funds, index funds, and sector funds.

• Stock split is when a company increases the number of shares outstanding by issuing more shares to current shareholders.

• Ex-dividend is when a stock trades without the dividend payment included in the share price.

• Bonus shares are additional shares giv...read more

Different types of funds include mutual funds, exchange-traded funds (ETFs), and hedge funds. NAV stands for Net Asset Value and TNA stands for Total Net Assets.

• Mutual funds are investment vehicles that pool money from multiple investors to invest in a diversified portfolio of securities.

• ETFs are similar to mutual funds but trade on stock exchanges like individual stocks.

• Hedge funds are alternative investment vehicles that typically have more flexible investment strategies an...read more

Both statements are important, as they may have different implications and consequences depending on the context.

• The importance of each statement depends on the situation and the goals of the research.

• One statement may be more relevant for a specific research question or hypothesis.

• Both statements should be considered and analyzed in order to draw accurate conclusions.

• For example, in a study on the effectiveness of a new drug, both the positive and negative outcomes should be...read more

Financial position refers to the overall financial health of an individual or organization.

• It includes assets, liabilities, and equity.

• A strong financial position means having more assets than liabilities.

• Examples of financial position indicators include net worth, debt-to-equity ratio, and liquidity ratios.

• Financial position can be used to assess creditworthiness and investment potential.

The problem is to find the length of the smallest subarray in a given array with its sum greater than a given value.

• Iterate through the array and keep track of the current subarray sum

• If the current sum becomes greater than the given value, update the minimum subarray length

• If the current sum becomes negative, reset the sum and start a new subarray

• Return the minimum subarray length

A zero coupon bond is a debt security that does not pay interest but is sold at a discount and redeemed at face value.

• Zero coupon bonds are issued at a discount to their face value, meaning they are sold for less than they will be worth at maturity.

• Investors earn a return on zero coupon bonds through the difference between the discounted purchase price and the face value received at maturity.

• Since zero coupon bonds do not make periodic interest payments, they are also known a...read more

A mutual fund is a type of investment vehicle that pools money from multiple investors to invest in a diversified portfolio of stocks, bonds, or other securities.

• Mutual funds are managed by professional fund managers who make investment decisions on behalf of the investors.

• Investors buy shares in the mutual fund and the value of their investment is determined by the performance of the underlying securities in the portfolio.

• Mutual funds offer investors the benefits of diversif...read more

The task is to determine whether a given linked list is circular or not.

• A linked list is circular if the next pointer of the last node points to the first node.

• An empty linked list is also considered circular.

• Check if any node has its next pointer equal to NULL.

• All the integers in the linked list are unique.

• The next pointer of a node with i'th integer is linked to the node with data (i+1)'th integer.

The task is to find the maximum elements for each subarray of size K in a given array.

• Iterate through the array and maintain a deque of indices of the maximum elements in the current window of size K.

• For each new element, remove indices from the deque that are outside the current window.

• Add the index of the new element to the deque, and print the maximum element of the window if the first index in the deque is outside the window.

The income statement shows a company's revenues and expenses, while the balance sheet shows its assets, liabilities, and equity.

• Income statement includes revenues, cost of goods sold, gross profit, operating expenses, net income, etc.

• Balance sheet includes assets (current and non-current), liabilities (current and non-current), and equity.

• Examples of items on income statement: sales revenue, salaries expense, rent expense, interest income, etc.

• Examples of items on balance she...read more

A trigger is a special type of stored procedure that automatically executes in response to certain events.

• Triggers are used to enforce business rules or to perform complex calculations.

• There are two types of triggers: DML triggers and DDL triggers.

• DML triggers fire in response to DML events (INSERT, UPDATE, DELETE).

• DDL triggers fire in response to DDL events (CREATE, ALTER, DROP).

• Triggers can be used to audit changes to data, enforce referential integrity, or perform custom v...read more

Bonus shares are additional shares given to existing shareholders, zero coupon bonds are bonds that do not pay interest, and mutual funds are investment vehicles that pool money from multiple investors to invest in various securities.

• Bonus shares are given to existing shareholders as a reward for holding the company's shares.

• Zero coupon bonds are sold at a discount to their face value and do not pay interest, but are redeemed at face value at maturity.

• Mutual funds are managed...read more

Context filter, set, and parameter are key concepts in BI development for filtering data based on specific criteria.

• Context filter is used to filter data within a specific context or scope in a BI report or dashboard.

• Set is a predefined group of values that can be used as a filter in BI tools.

• Parameter is a variable that can be used to dynamically change the filter criteria in a BI report.

• Examples: Context filter can be applied to a specific region in a sales report, a set ca...read more

The cash flow statement has three main components: operating activities, investing activities, and financing activities.

• Operating activities include cash inflows and outflows from day-to-day business operations, such as sales and expenses.

• Investing activities include cash inflows and outflows from investments in long-term assets, such as property and equipment.

• Financing activities include cash inflows and outflows from financing sources, such as loans and stock issuances.

• The ...read more

Office 365 is a cloud-based suite of productivity tools and services provided by Microsoft.

• Office 365 is a subscription-based service that includes popular Microsoft applications like Word, Excel, PowerPoint, and Outlook.

• It also offers cloud storage, email hosting, and collaboration tools like SharePoint and Teams.

• Office 365 allows users to access their files and applications from anywhere, on any device, as long as they have an internet connection.

• It provides regular updates...read more

Indexes in SQL are used to improve the performance of queries by allowing faster data retrieval.

• Indexes are created on one or more columns of a table.

• They work like a book index, allowing the database to quickly find the data that matches a query.

• Indexes can be clustered or non-clustered, and can be unique or non-unique.

• Creating too many indexes can slow down data insertion and updates.

• Examples of indexes include primary keys, foreign keys, and indexes on frequently queried c...read more

Linux permissions include read, write, execute, setuid, and setgid.

• Read permission allows a user to view the contents of a file or directory.

• Write permission allows a user to modify the contents of a file or directory.

• Execute permission allows a user to run a file or access the contents of a directory.

• Setuid permission allows a user to execute a file with the permissions of the file's owner.

• Setgid permission allows a user to execute a file with the permissions of the file's g...read more

Extensions in Tableau are custom add-ons that enhance the functionality of Tableau by allowing users to integrate external services and applications.

• Extensions can be used to connect Tableau with third-party applications, services, and data sources.

• They can be developed using HTML, CSS, and JavaScript to create custom visualizations, write-back capabilities, and more.

• Examples of extensions include integrating Tableau with Google Maps for geospatial analysis, embedding Tableau...read more

Adds stands for Active Directory Domain Services. It is a directory service provided by Microsoft for managing network resources.

• Adds is used to manage users, groups, computers, and other network resources in a Windows domain.

• It provides a centralized authentication and authorization mechanism for accessing network resources.

• Adds allows administrators to define and enforce security policies, manage software installations, and deploy updates across the network.

• It enables singl...read more

Row level security is a feature that restricts access to specific rows of data in a database based on the user's permissions.

• Row level security limits access to certain rows of data based on user roles or attributes

• It ensures that users can only see the data they are authorized to access

• For example, a sales manager may only be able to view sales data for their region

VPN stands for Virtual Private Network. It is a secure connection that allows users to access a private network over a public network.

• VPN creates a secure and encrypted connection between the user's device and the private network.

• It provides privacy and anonymity by masking the user's IP address and encrypting their internet traffic.

• VPN is commonly used to access company networks remotely, bypass geo-restrictions, and enhance online security.

• Examples of VPN protocols include ...read more

Use a hashmap to find the repeating element in the array of strings

• Iterate through the array and store each element in a hashmap with its frequency

• Check for any element with frequency greater than 1, that is the repeating element

I will handle escalation by identifying the root cause, communicating effectively, and finding a solution that satisfies the client.

• Listen to the client's concerns and empathize with their situation

• Identify the root cause of the issue and take ownership of the problem

• Communicate effectively with the client and keep them updated on the progress

• Find a solution that satisfies the client's needs and expectations

• Follow up with the client to ensure their satisfaction and prevent fu...read more

Encapsulation, Inheritance, Polymorphism, Abstraction

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Inheritance: Ability of a class to inherit properties and behavior from another class.

• Polymorphism: Ability to present the same interface for different data types.

• Abstraction: Hiding the complex implementation details and showing only the necessary features.