Filter interviews by
It was round with solution architect and he asked to create a simple Web API which will do simple CRUD operations. Basic idea was to see how you write code and few interview questions asked related to your code, it was kind of pair programming test.
I applied via Approached by Company and was interviewed in Nov 2024. There were 2 interview rounds.
First round is technical MCQ question which is 15 and gives 10 min . So that cracked easly. Simple question
I applied via Company Website and was interviewed in Oct 2024. There was 1 interview round.
Filters in .NET are used to perform logic before or after an action method is executed.
Filters can be used for authorization, logging, exception handling, etc.
Examples include AuthorizeFilter, ActionFilter, ExceptionFilter, ResultFilter.
Filters can be applied globally, at controller level, or at action level.
PUT is used to update or replace an existing resource, PATCH is used to partially update a resource, and POST is used to create a new resource.
PUT is idempotent, meaning multiple identical requests will have the same effect as a single request.
PATCH is not necessarily idempotent and is used to make partial updates to a resource.
POST is used to create a new resource on the server.
Extension methods allow adding new methods to existing types, value types store data directly, reference types store references to data, migration in code-first approach involves updating database schema, Configure method in .NET Core configures services and middleware.
Extension methods are static methods that can be called as if they were instance methods on an existing type.
Value types store data directly on the stac...
Drop, delete, and truncate are SQL commands used to remove data from a table, but they have different functionalities.
DROP: Used to remove an entire table or database
DELETE: Used to remove specific rows from a table
TRUNCATE: Used to remove all rows from a table, but keeps the table structure
Routing in MVC is the process of mapping URLs to controller actions.
Routing determines which controller and action to execute based on the URL requested
Routes are defined in the RouteConfig.cs file in MVC applications
Routes can include parameters that are passed to the controller action
Routes can be customized using route constraints and route attributes
String manipulation , array related questions, oops concept
I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.
Extension methods in C# allow developers to add new methods to existing types without modifying the original source code.
Extension methods must be defined in a static class.
The first parameter of an extension method specifies the type being extended and is preceded by the 'this' keyword.
Extension methods can be called as if they were instance methods of the extended type.
HTML helpers in MVC are methods that help generate HTML controls in a view.
HTML helpers are used to render HTML controls in a view in ASP.NET MVC.
They provide a way to encapsulate HTML markup and code to generate HTML controls.
Examples include TextBox(), DropDownList(), CheckBox(), etc.
They help in reducing the amount of HTML code written in views and provide a more structured way to work with HTML controls.
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
posted on 10 Apr 2022
I applied via Walk-in and was interviewed before Apr 2021. There were 2 interview rounds.
Do not remember exactly but i guess 1 hour aptitude test.
I applied via Company Website and was interviewed in Oct 2021. There was 1 interview round.
DI in .Net Core allows for loosely coupled and testable code.
Add services to the DI container in Startup.cs
Inject dependencies into classes using constructor injection
Use built-in DI or third-party libraries like Autofac
Configure lifetime of services with AddScoped, AddTransient, or AddSingleton
To call DI in controller, inject the required service in the constructor of the controller.
Add required service in ConfigureServices method of Startup.cs
Inject the service in the constructor of the controller
Use the service in the controller methods
Validation in MVC
Use data annotations for server-side validation
Use jQuery validation for client-side validation
Customize validation messages using ErrorMessage property
Use ModelState.IsValid to check if validation passed
Use ModelState.AddModelError to add validation errors
WebAPI is a framework for building HTTP services that can be consumed by a broad range of clients.
Create a new WebAPI project in Visual Studio
Define API endpoints using HTTP verbs (GET, POST, PUT, DELETE)
Use attribute routing to map URLs to actions
Return data in JSON format
Secure the API using authentication and authorization
Clustered indexes determine physical order of data, non-clustered indexes are separate structures.
Clustered indexes sort and store data rows in the table based on their key values.
Non-clustered indexes have a separate structure that includes the indexed columns and a pointer to the data row.
Tables can have only one clustered index, but multiple non-clustered indexes.
Clustered indexes are faster for retrieving large amo...
Query optimization in SQL
Use indexes to speed up queries
Avoid using SELECT *
Use JOINs instead of subqueries
Avoid using functions in WHERE clauses
Use EXPLAIN to analyze query performance
Transactions in SQL ensure data consistency and integrity during multiple operations.
Transactions group multiple SQL statements into a single unit of work.
They ensure that all statements are executed or none are executed.
They provide data consistency and integrity during multiple operations.
Transactions can be started with BEGIN TRANSACTION and committed with COMMIT or rolled back with ROLLBACK.
They are useful in situa...
Inner join returns only matching records while outer join returns all records from both tables.
Inner join is used to retrieve records that have matching values in both tables.
Outer join is used to retrieve all records from both tables, even if there are no matching values.
Left outer join returns all records from the left table and matching records from the right table.
Right outer join returns all records from the right
Senior Software Engineer
57
salaries
| ₹20 L/yr - ₹43 L/yr |
Principal Software Engineer
9
salaries
| ₹45 L/yr - ₹55 L/yr |
QA Engineer
5
salaries
| ₹13 L/yr - ₹24 L/yr |
Senior Software Developer
5
salaries
| ₹26 L/yr - ₹42.1 L/yr |
Application Support Specialist
5
salaries
| ₹12.5 L/yr - ₹24 L/yr |
Infosys
TCS
Wipro
HCLTech