Filter interviews by
I applied via Recruitment Consulltant and was interviewed before Oct 2023. There were 3 interview rounds.
Coding logical thinking
I was interviewed in Oct 2021.
Round duration - 60 minutes
Round difficulty - Easy
It was my first round - they asked basics of OOPS,DBMS and operating systems. Be prepared with System Design also.
ACID properties are a set of properties that guarantee reliability and consistency in database transactions.
ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity ensures that a transaction is treated as a single unit of work, either all of its operations are executed or none.
Consistency ensures that a transaction brings the database from one valid state to another.
Isolation ensures that concurrent...
A transaction is a logical unit of work that consists of multiple database operations that must be executed as a single, indivisible unit.
A transaction ensures data consistency and integrity.
It follows the ACID properties: Atomicity, Consistency, Isolation, and Durability.
Transactions are used to maintain data integrity in databases.
Examples of transactions include transferring funds between bank accounts or updating i
SQL databases are relational databases that use structured query language, while NoSQL databases are non-relational databases that use various data models.
SQL databases are based on a fixed schema, while NoSQL databases are schema-less.
SQL databases are better suited for complex queries and structured data, while NoSQL databases are better for unstructured and semi-structured data.
SQL databases ensure ACID (Atomicity, ...
A semaphore is a synchronization object that controls access to a shared resource through the use of a counter.
Semaphores are used to manage concurrent access to shared resources in multi-threaded or multi-process environments.
They can be used to limit the number of threads or processes that can access a resource simultaneously.
Semaphores can have two types: counting semaphores and binary semaphores.
Counting semaphores...
Multitasking in Java can be achieved using threads.
Create multiple threads to execute tasks concurrently.
Use the Thread class or the Runnable interface to define the tasks.
Use synchronization mechanisms like locks or semaphores to coordinate access to shared resources.
Java provides built-in support for multitasking with the Thread class and the Executor framework.
Example: creating two threads to perform different tasks
Design a schema for a restaurant app like Zomato.
Create tables for restaurants, users, reviews, and orders
Include columns for restaurant details like name, address, cuisine type
Include columns for user details like name, email, and password
Link reviews to restaurants and users
Link orders to restaurants and users
Consider additional tables for menu items, categories, and ratings
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 4 : Prepare OS and DBMS properly.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via Recruitment Consulltant and was interviewed before Feb 2023. There was 1 interview round.
The minimum weight to reach the bottom right corner in a matrix starting from the top left by moving only down and right.
Use dynamic programming to calculate the minimum weight at each cell by considering the weights of the cells above and to the left.
At each cell, the minimum weight to reach that cell is the minimum of the weight of the cell itself plus the minimum weight of the cells above and to the left.
Example: Fo...
I applied via Instahyre and was interviewed in Oct 2021. There was 1 interview round.
Design a schema for a restaurant app like Zomato.
Create tables for restaurants, menus, reviews, and users.
Include columns for restaurant name, location, cuisine, and ratings.
Add columns for menu items, prices, and descriptions.
Include user information such as name, email, and password.
Create relationships between tables using foreign keys.
Implement search and filter functionality for restaurants and menus.
Allow users t...
A transaction is a unit of work that is performed on a database.
A transaction is a sequence of database operations that are treated as a single unit of work.
It ensures that all the operations are completed successfully or none of them are performed.
Transactions are used to maintain data consistency and integrity in a database.
Examples of transactions include transferring money between bank accounts or updating inventor
SQL is a relational database while NoSQL is a non-relational database.
SQL databases use structured query language while NoSQL databases use unstructured query language.
SQL databases are vertically scalable while NoSQL databases are horizontally scalable.
SQL databases are good for complex queries while NoSQL databases are good for large amounts of unstructured data.
Examples of SQL databases include MySQL, Oracle, and Po...
Multitasking in Java can be achieved through multithreading.
Create a new thread using the Thread class or Runnable interface
Use the start() method to start the thread
Synchronize shared resources to avoid race conditions
Use wait() and notify() methods for inter-thread communication
Example: creating a thread to perform a long-running task while the main thread continues executing other tasks
Semaphores are a synchronization tool used to control access to a shared resource.
Semaphores can be used to prevent race conditions in multi-threaded programs.
They can be used to limit the number of concurrent accesses to a resource.
Semaphores can be binary (0 or 1) or counting (0 to n).
Examples of semaphore functions include wait(), signal(), and init().
Arcesium interview questions for designations
I applied via Company Website and was interviewed in Nov 2021. There were 3 interview rounds.
Get interview-ready with Top Arcesium Interview Questions
I applied via Approached by Company and was interviewed in Jan 2022. There were 2 interview rounds.
A 1-hour long coding test was conducted
Hashing is a process of converting data into a fixed-size output. Collision occurs when two different inputs produce the same output.
Hashing is used for indexing and retrieving data quickly
Hash functions should be deterministic and produce the same output for the same input
Collisions can be resolved using techniques like chaining or open addressing
Examples of hashing algorithms include MD5, SHA-1, and SHA-256
I applied via campus placement at National Institute of Technology (NIT), Raipur and was interviewed before Mar 2021. There were 4 interview rounds.
90 minute test on hacker rank consisting of 3 coding questions all of medium difficulty. Most candidates are required to solve more than 1 question.
Find the lowest common ancestor of a binary tree.
Traverse the tree recursively from the root node.
If the current node is null or matches either of the given nodes, return the current node.
Recursively search for the nodes in the left and right subtrees.
If both nodes are found in different subtrees, return the current node.
If both nodes are found in the same subtree, continue the search in that subtree.
Find first missing positive integer from an array of non-negative integers.
Create a hash set to store all positive integers in the array
Loop through the array and add all positive integers to the hash set
Loop through positive integers starting from 1 and return the first missing integer not in the hash set
Design a parking lot
Consider the size and capacity of the parking lot
Decide on the layout and organization of parking spaces
Implement a system to manage parking availability and reservations
Include features like ticketing, payment, and security
Consider scalability and future expansion
Group list of strings into distinct anagrams.
Create a hash table with sorted string as key and list of anagrams as value.
Iterate through the list of strings and add each string to its corresponding anagram list in the hash table.
Return the values of the hash table as a list of lists.
Top trending discussions
posted on 13 Dec 2024
I faced a technical challenge while implementing a complex algorithm for real-time data processing.
Identified the bottleneck in the algorithm by profiling the code
Optimized the algorithm by implementing data structures and algorithms with lower time complexity
Tested the optimized solution thoroughly to ensure correctness and performance
Collaborated with team members to brainstorm alternative approaches
JavaScript frameworks provide pre-written code to simplify and speed up web development.
Helps in organizing code and improving code quality
Provides reusable components for faster development
Offers built-in features like routing, state management, and data binding
Examples: React, Angular, Vue
OOPs concepts are fundamental principles in object-oriented programming that help in organizing and designing code.
Encapsulation: Bundling data and methods that operate on the data into a single unit (class).
Inheritance: Allowing a class to inherit properties and behavior from another class.
Polymorphism: Ability of objects to take on multiple forms or behaviors.
Abstraction: Hiding the complex implementation details and...
Design patterns are reusable solutions to common problems in software design.
Design patterns help in creating flexible, maintainable, and scalable software.
They provide a common language for developers to communicate about solutions.
Examples include Singleton, Factory, Observer, and Strategy patterns.
posted on 9 May 2024
based on 2 interviews
2 Interview rounds
based on 31 reviews
Rating in categories
Analyst
310
salaries
| ₹7.6 L/yr - ₹20 L/yr |
Senior Analyst
310
salaries
| ₹9.5 L/yr - ₹27 L/yr |
Senior Software Engineer
226
salaries
| ₹15 L/yr - ₹42 L/yr |
Software Engineer
187
salaries
| ₹9 L/yr - ₹33 L/yr |
Financial Analyst
150
salaries
| ₹8.5 L/yr - ₹19 L/yr |
Edelweiss
JPMorgan Chase & Co.
Goldman Sachs
Morgan Stanley