Urbanpiper Technology BDM Interview Questions and Answers for Experienced

Regex for email validation

• Start with a string of characters followed by @ symbol

• Followed by a string of characters and a period

• End with a string of characters with a length of 2-6 characters

• Allow for optional subdomains separated by periods

• Disallow special characters except for . and _ in username

Print prime numbers in a given range and optimize the solution.

• Use Sieve of Eratosthenes algorithm to generate prime numbers efficiently

• Start with a boolean array of size n+1, mark all as true

• Loop through the array and mark all multiples of each prime as false

• Print all the indexes that are still marked as true

Find angle between hour and minute hand in a clock given the time.

• Calculate the angle made by the hour hand with respect to 12 o'clock position

• Calculate the angle made by the minute hand with respect to 12 o'clock position

• Find the difference between the two angles and take the absolute value

• If the angle is greater than 180 degrees, subtract it from 360 degrees to get the smaller angle

To un-hash a string, use a reverse algorithm to convert the hash back to the original string.

• Create a reverse algorithm that takes the hash as input and outputs the original string

• Use the same logic as the hash function but in reverse order

• If the hash function used a specific algorithm, use the inverse of that algorithm to un-hash the string

I am a Senior Associate in the field of finance, specializing in investment management.

• I have expertise in analyzing financial data and making investment recommendations.

• I work closely with clients to understand their financial goals and risk tolerance.

• I monitor market trends and economic indicators to make informed investment decisions.

• I have experience in portfolio management and asset allocation.

• I may hold certifica...read more

My ambition is to become a respected leader in my field, making a positive impact through innovative solutions and mentorship.

• To continuously learn and grow in my role

• To lead and inspire a team towards success

• To contribute to the advancement of the organization and industry

• To mentor and guide junior colleagues in their professional development

I have 5 years of experience managing warehouse operations, including inventory control, shipping/receiving, and staff supervision.

• Implemented efficient inventory management system to reduce errors and improve accuracy

• Led team in achieving 99% on-time shipping rate by optimizing workflow processes

• Trained staff on safety protocols and equipment operation to ensure compliance with OSHA regulations

Diameter of a binary tree is the longest path between any two leaf nodes.

• Calculate the height of left and right subtrees recursively.

• Calculate the diameter recursively using the formula max(left_height + right_height + 1, max(left_diameter, right_diameter)).

• Return the maximum diameter.

To find interchanged terms from an AP series

• Identify the common difference between terms

• Swap the positions of adjacent terms

• Check if the new series is also an AP

• Repeat until no more interchanged terms can be found

Database indexing is a technique to improve the performance of database queries.

• Indexing creates a data structure that allows for faster retrieval of data.

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

• Queries that use indexed columns can be executed faster.

• Indexes can be clustered or non-clustered.

• Clustered indexes determine the physical order of data in a table.

• Non-clustered indexes create a separate structure...read more