Filter interviews by
Level Order Traversal for Binary Tree is a method to visit all nodes level by level starting from the root.
Use a queue data structure to keep track of nodes at each level
Start by pushing the root node into the queue
While the queue is not empty, dequeue a node, visit it, and enqueue its children
Left join includes all records from the left table and matching records from the right table, while right join includes all records from the right table and matching records from the left table.
Left join keeps all records from the left table, even if there are no matches in the right table.
Right join keeps all records from the right table, even if there are no matches in the left table.
Example: If we have a table of em...
I applied via Campus Placement and was interviewed before Feb 2023. There were 2 interview rounds.
Basic aptitude questions Learn from Indiabix
A stored procedure is a precompiled set of SQL statements that can be executed on a database server.
Stored procedures are used to encapsulate and execute complex database operations.
They can be used to improve performance by reducing network traffic.
Stored procedures can be parameterized and reused across multiple applications.
They provide a level of security by allowing access to the database only through the procedur...
A SQL query to move a table from one schema to another.
Use the ALTER TABLE statement to rename the table and move it to the new schema.
Specify the new schema name in the ALTER TABLE statement.
Ensure that the user executing the query has the necessary privileges to perform the operation.
SSMS is a management tool for SQL Server, SSIS is an ETL tool, and SSAS is a BI tool for analyzing data.
SSMS (SQL Server Management Studio) is a graphical management tool for SQL Server.
SSIS (SQL Server Integration Services) is an ETL (Extract, Transform, Load) tool used for data integration and workflow applications.
SSAS (SQL Server Analysis Services) is a BI (Business Intelligence) tool used for analyzing and reporti...
Cubes are multidimensional data structures used for analysis and reporting. They differ from databases in their structure and purpose.
Cubes store data in a multidimensional format, allowing for efficient analysis and reporting.
They are designed to handle large volumes of data and provide fast query performance.
Cubes use dimensions, measures, and hierarchies to organize and analyze data.
Unlike databases, cubes are optim...
Top trending discussions
I was interviewed in Jul 2024.
Leet code medium level question
Hashmap is a data structure that stores key-value pairs and allows for fast retrieval of values based on keys.
Hashmap uses a hashing function to map keys to indices in an array.
It allows for constant time complexity O(1) for insertion, deletion, and retrieval operations.
Example: HashMap<String, Integer> map = new HashMap<>(); map.put("key", 123); int value = map.get("key");
I applied via campus placement at International Institute of Information Technology (IIIT), Allahabad and was interviewed in Nov 2024. There was 1 interview round.
Round 1: DSA round asked Two DSA question in which one is Leetcode medium and another is leetcode Hard. I answer both of them but not selected in the further HR round.
Round 2: HR round
posted on 16 Aug 2024
Pagination in JPA allows for retrieving a subset of results from a query by specifying a limit and offset.
Use the setFirstResult() method to specify the starting index of the results to retrieve
Use the setMaxResults() method to specify the maximum number of results to retrieve
Combine setFirstResult() and setMaxResults() to implement pagination in JPA queries
To create a RESTful API, define endpoints, use HTTP methods, handle requests and responses, and follow REST principles.
Define endpoints for different resources (e.g. /users, /products)
Use HTTP methods like GET, POST, PUT, DELETE for CRUD operations
Handle requests and responses in JSON format
Follow REST principles like statelessness, uniform interface, and client-server architecture
SQL Server Agent is a job scheduling tool in SQL Server. Abstract classes cannot be instantiated. SPs are faster than functions. Microservice concepts. IEnumerable vs IQueryable.
SQL Server Agent is a job scheduling tool in SQL Server for automating tasks like backups, database maintenance, etc.
Abstract classes cannot be instantiated because they are incomplete and meant to be extended by subclasses.
Extension methods ca...
A record in C# is a data structure that stores a fixed number of fields of different data types.
A record in C# is similar to a struct in C++, containing fields to store data.
Example: 'public record Person { public string Name; public int Age; }'
Generic method for summation: 'public T Sum
Test cases can include checking the su...
I applied via Campus Placement
Aptitude test was easy level and moderate level.
Coding test was held in the google form which was very easy.
The volatile keyword in software engineering is used to indicate that a variable's value can be modified by multiple threads.
Volatile keyword ensures that the variable's value is always read from and written to the main memory, rather than cached in a thread's local cache.
It is used to prevent unexpected behavior in multi-threaded environments where multiple threads may access and modify the same variable simultaneousl...
An abstract class is a class that cannot be instantiated and is meant to be subclassed.
An abstract class can have abstract methods that must be implemented by its subclasses.
An abstract class can also have non-abstract methods that can be inherited by its subclasses.
An abstract class provides a common interface for its subclasses.
An abstract class can have instance variables and constructors.
An abstract class cannot be...
Abstract classes are used to provide a common interface and partial implementation for related classes.
Abstract classes are used when you want to create a base class that cannot be instantiated on its own but can be inherited by other classes.
They are useful when you want to define common methods and properties that multiple related classes should have.
Abstract classes can have both abstract and non-abstract methods.
Ab...
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
Arrays are fixed in size and store elements of the same data type, while collections are dynamic in size and can store elements of different data types.
Arrays have a fixed size, while collections can dynamically resize.
Arrays store elements of the same data type, while collections can store elements of different data types.
Arrays use indexes to access elements, while collections use iterators or other methods.
Examples:...
I applied via Approached by Company and was interviewed in Feb 2024. There were 4 interview rounds.
DSA coding 2-3 question
Java, DSA coding, java 8 coding, multithreading
Java8, spring-boot, DSA coding
based on 2 interviews
Interview experience
based on 1 review
Rating in categories
Software Engineer
694
salaries
| ₹5 L/yr - ₹15.5 L/yr |
Software Engineer Level 1
590
salaries
| ₹5 L/yr - ₹13.4 L/yr |
Software Engineer2
292
salaries
| ₹8 L/yr - ₹18 L/yr |
Associate Software Engineer
132
salaries
| ₹3.6 L/yr - ₹13 L/yr |
Senior Software Engineer
81
salaries
| ₹11.5 L/yr - ₹25 L/yr |
TCS
Infosys
Wipro
HCLTech