Coxswain Technologies Interview Questions and Answers

To find the 3rd transaction of a user from the Uber cab dataset.

• Identify the user's transactions in the dataset

• Sort the transactions by date/time

• Select the 3rd transaction of the user

To find the last quarter ordered product from logistics dataset.

• Identify the date range for the last quarter

• Filter the dataset for orders within that date range

• Identify the product ordered in the last quarter

Oracle architecture is a multi-tiered system with components like client, server, and database.

• Oracle architecture consists of client, server, and database components.

• The client communicates with the server to access the database.

• The server processes the client's requests and interacts with the database.

• The database stores and manages the data.

• Oracle architecture is designed to be scalable and secure.

Merge two sorted arrays with alternating lowest and highest elements.

• Create a new array to store the result

• Use two pointers to iterate through the two input arrays

• Alternate between adding the lowest and highest elements to the result array

SplitWise is a platform for splitting expenses among friends or groups.

• Allow users to create groups and add expenses

• Calculate each user's share of the expenses

• Send notifications to users for pending payments

• Support multiple currencies for international groups

Design API Rate Limiter to control the number of requests a user can make within a specific time frame.

• Implement a token bucket algorithm to track and limit the number of requests per user.

• Use a sliding window to track the time frame for request limits.

• Consider using a distributed cache like Redis to store and manage request limits.

• Provide appropriate error responses when the rate limit is exceeded.

• Allow for customizat...read more

CT and PT are electrical devices used for current and voltage measurement in power systems.

• CT stands for Current Transformer, used to step down high currents to a measurable level for protection and metering purposes.

• PT stands for Potential Transformer, used to step down high voltages to a measurable level for protection and metering purposes.

• CTs and PTs are commonly used in power systems to provide accurate measuremen...read more