EarlySalary Services Senior Software Engineer Interview Questions and Answers

Auto complete Input Search box with Dropdown

Q1. Machine coding round for SQL
Add your answer

Q1. Explain Concurrency
Ans. 
Concurrency is the ability of a system to execute multiple tasks simultaneously.
• Concurrency allows multiple tasks to run concurrently, improving performance and efficiency.

• Concurrency can be achieved through multithreading or multiprocessing.

• Example: A web server handling multiple requests simultaneously using multithreading.
Answered by AI
Add your answer
Q2. Explain Acid principles
Ans. 
ACID principles are a set of properties that guarantee database transactions are processed reliably.
• Atomicity: Transactions are all or nothing. If one part of the transaction fails, the entire transaction is rolled back.

• Consistency: Transactions bring the database from one valid state to another. All constraints are satisfied.

• Isolation: Transactions are isolated from each other until they are completed.

• Durability: Once...read more
Answered by AI
Add your answer

Q1. In memory sql db
Ans. 
In-memory SQL databases store data in memory for faster access and processing.
• In-memory databases keep all data in RAM for quicker retrieval compared to disk-based databases.

• Examples include SQLite in-memory database and Redis.

• They are commonly used for caching, real-time analytics, and temporary data storage.
Answered by AI
Add your answer

Asked to do coding for RDBMS using any programing language

Q1. Machine coding: Design in-memory document search
Add your answer

Q1. HLD: Design a ad-click aggregation service
Ans. 
Design an ad-click aggregation service for tracking and analyzing ad clicks.
• Use a distributed system to handle high volume of ad click data

• Implement real-time processing for immediate insights on ad performance

• Utilize a database to store aggregated ad click data for reporting and analysis
Answered by AI
Add your answer

Q1. Design a in-memory cache
Ans. 
Design a high-performance in-memory cache system for storing and retrieving data efficiently.
• Use a hash table or a key-value store to store data in memory

• Implement caching strategies like LRU (Least Recently Used) or LFU (Least Frequently Used) to manage cache eviction

• Consider using a distributed cache for scalability and fault tolerance

• Optimize cache size and expiration policies based on the application's data access
Answered by AI
Add your answer

Q1. Rating Service Low level design
Add your answer