Filter interviews by
I applied via LinkedIn and was interviewed in Oct 2022. There were 2 interview rounds.
Stored procedures are used to perform an action, while functions return a value.
Stored procedures are precompiled and stored in the database, while functions are compiled at runtime.
Functions can be used in SQL statements, while stored procedures cannot be used in SQL statements.
Functions can be called from within stored procedures, but stored procedures cannot be called from within functions.
Functions can have input p...
The == operator compares values, while the === operator compares values and types.
The == operator performs type coercion, while the === operator does not.
The == operator returns true if the values are equal after type coercion, while the === operator returns true only if the values and types are equal.
For example, 1 == '1' returns true, but 1 === '1' returns false.
Top trending discussions
I applied via LinkedIn and was interviewed in Nov 2024. There was 1 interview round.
I applied via Approached by Company and was interviewed in Oct 2023. There were 2 interview rounds.
Abstract class is used when there is a need for default implementation, while interfaces are used for multiple inheritance.
Abstract classes can have both abstract and non-abstract methods, while interfaces can only have abstract methods.
Abstract classes can provide default implementations for methods, while interfaces cannot.
Interfaces allow a class to implement multiple interfaces, but can only inherit from one abstra...
NET core is a cross-platform, open-source framework for building modern, cloud-based, internet-connected applications. NET framework is a Windows-only framework for building Windows desktop applications. NET is a general term encompassing both .NET core and .NET framework.
NET core is cross-platform and open-source, while .NET framework is Windows-only.
.NET core is modular and lightweight, allowing for faster performanc...
Pipelines and Middlewares in .NET are used for request processing and can be configured using middleware components.
Pipelines in .NET are used to define a series of middleware components that process an HTTP request.
Middlewares are components that can handle requests and responses in the pipeline.
To configure pipelines and middlewares in .NET, you can use the 'UseMiddleware' method in the 'Configure' method of the Star...
App.Use() is used for adding middleware to the request pipeline, while App.Run() is used for handling the request directly.
App.Use() is used to add middleware components to the request pipeline.
App.Run() is used to handle the request directly without passing it to the next middleware component.
App.Use() is typically used for setting up middleware like authentication, logging, etc.
App.Run() is used for handling the fina...
String is immutable, while StringBuilder is mutable. StringBuilder is faster and more memory efficient for string manipulation.
String is immutable, meaning once created, it cannot be changed. StringBuilder is mutable, allowing for efficient string manipulation.
StringBuilder is faster than String for concatenating multiple strings, as it does not create a new string object each time.
String uses more memory as it creates...
Unique, Primary Key, Clustered, and Non-Clustered Indices are all used in database management to enforce data integrity and improve query performance.
Unique constraint ensures that all values in a column are unique, but allows NULL values.
Primary Key constraint ensures that all values in a column are unique and not NULL. Each table can have only one Primary Key.
Clustered Index physically reorders the way records in the...
JWT authentication and OAuth example for API
Implement JWT authentication by generating a token upon user login and including it in the Authorization header of API requests
Use OAuth for user authorization by obtaining access tokens from a third-party provider like Google or Facebook
Ensure API endpoints validate JWT tokens and OAuth access tokens before allowing access to resources
Both $.post and $.ajax are methods in jQuery used for making AJAX requests, but $.ajax is more versatile and customizable.
Both $.post and $.ajax are used for making AJAX requests in jQuery.
$.post is a shorthand method for $.ajax with predefined settings for POST requests.
$.ajax is more versatile and customizable, allowing for different types of requests and more options.
Example: $.post('example.php', {data: 'example'},...
I was interviewed in Aug 2024.
Code for prime numbers
Dispose is used to release unmanaged resources, while finalize is used for cleanup before an object is destroyed.
Dispose is called explicitly by the developer, while finalize is called by the garbage collector.
Dispose should be implemented in classes that directly use unmanaged resources like file handles or database connections.
Finalize is used for cleanup tasks like closing files or releasing memory.
Implement IDispos...
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
Mettl aptitude reasoning and technical MCQ
I applied via Campus Placement and was interviewed in May 2021. There were 5 interview rounds.
Union combines and removes duplicates, Union All combines all rows including duplicates.
Union merges the results of two or more SELECT statements into a single result set.
Union All returns all rows from all SELECT statements, including duplicates.
Union requires the same number of columns in all SELECT statements, while Union All does not.
Union sorts the result set and removes duplicates, while Union All does not.
Union ...
Abstract methods are methods without implementation in abstract classes, while interfaces are contracts that define methods.
Abstract classes can have both abstract and non-abstract methods, while interfaces can only have abstract methods.
A class can implement multiple interfaces, but can only inherit from one abstract class.
Abstract classes can have constructors, while interfaces cannot.
Interfaces can have properties,
The optimal solution approach for the Travelling Salesman Problem involves using algorithms such as the Nearest Neighbor Algorithm and the 2-Opt Algorithm.
The Nearest Neighbor Algorithm starts at a random city and selects the nearest unvisited city as the next stop.
The 2-Opt Algorithm involves swapping two edges in the tour to see if it results in a shorter distance.
Other algorithms include the Genetic Algorithm and th...
No, only one primary key can be defined in a SQL table.
Primary key ensures uniqueness of each record in a table.
A table can have only one primary key constraint.
However, a composite primary key can be created using multiple columns.
I applied via Naukri.com and was interviewed in Mar 2020. There were 5 interview rounds.
JOINS are used in SQL to combine data from two or more tables based on a related column.
Inner JOIN returns only the matching rows from both tables
Equi JOIN is a type of Inner JOIN where the join condition is based on equality between two columns
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Divide array in two halves and keep each half in ascending order without using new Array.
Use Array.sort() method to sort the original array
Use Array.slice() method to divide the array into two halves
Use Array.reverse() method to reverse the second half of the array
Interfaces are contracts that define a set of methods and properties that a class must implement.
Interfaces provide a way to achieve abstraction and polymorphism in object-oriented programming.
They allow for loose coupling between classes and promote code reusability.
Interfaces can be used to define common behavior across multiple classes.
Example: IDisposable interface in C# ensures that an object can be properly dispo...
Inheritance is a mechanism in object-oriented programming where a class is based on another class.
Inheritance allows a subclass to inherit properties and methods from a superclass.
The subclass can also add its own properties and methods.
Examples include a Car class inheriting from a Vehicle class, or a Dog class inheriting from an Animal class.
based on 2 reviews
Rating in categories
Software Engineer
27
salaries
| ₹4.4 L/yr - ₹13.3 L/yr |
Senior Software Engineer
18
salaries
| ₹7.5 L/yr - ₹14.8 L/yr |
QA Engineer
10
salaries
| ₹3.6 L/yr - ₹8.8 L/yr |
System Analyst
8
salaries
| ₹6.2 L/yr - ₹24 L/yr |
Software Developer
7
salaries
| ₹4 L/yr - ₹11.5 L/yr |
TCS
Infosys
Wipro
HCLTech