i
TO THE NEW
Filter interviews by
Clear (1)
first() returns the first element of a sequence, while FirstOrDefault() returns the first element or a default value if the sequence is empty.
first() throws an exception if the sequence is empty, while FirstOrDefault() returns a default value (e.g. null) in that case.
Use first() when you expect the sequence to always have at least one element, and FirstOrDefault() when the sequence might be empty.
Example: var numbers =...
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: includes all records from the left table and matching records from the right table
Right join: includes all records from the right table and matching records from the left table
Example: Left join - SELECT * FROM table1...
Optimizing SQL queries involves using indexes, minimizing joins, and avoiding unnecessary columns.
Use indexes on columns frequently used in WHERE clauses
Minimize the use of JOIN operations
Avoid selecting unnecessary columns in the query
Consider using stored procedures for frequently executed queries
One tool used to check query slowness is SQL Server Profiler.
SQL Server Profiler can be used to trace and analyze query performance.
It provides detailed information on query execution, including duration, reads, writes, and more.
Users can identify slow queries and optimize them for better performance.
Other tools like Query Store in SQL Server Management Studio can also be used for monitoring query performance.
Repository pattern using EF core for data access layer
Create an interface for the repository with generic CRUD methods
Implement the repository interface with EF core for data access
Use dependency injection to inject the repository into services
Separate concerns by having repositories handle data access logic
I applied via Recruitment Consulltant
Top trending discussions
posted on 16 Feb 2025
I was interviewed before Feb 2024.
Normal code to write string manipulations
I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.
I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.
I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.
I applied via Campus Placement and was interviewed before Jan 2021. There were 2 interview rounds.
Good
I was interviewed in Sep 2016.
Developed a web-based project management tool for a software development company.
Used Agile methodology for development
Implemented features like task assignment, progress tracking, and team collaboration
Integrated with third-party tools like GitHub and Slack
Designed a user-friendly interface with responsive design
Deployed on AWS using EC2 and RDS
My CV showcases my experience in software development, including projects in Java, Python, and web development.
Experience in Java, Python, and web development
Worked on projects involving database management systems
Familiar with Agile development practices
I was interviewed in May 2017.
Developed a web-based project management system for tracking tasks and deadlines.
Used HTML, CSS, JavaScript for front-end development
Implemented backend using Node.js and MongoDB for database management
Incorporated user authentication and authorization features
Utilized Agile methodology for project management
based on 4 interviews
1 Interview rounds
based on 29 reviews
Rating in categories
Software Engineer
561
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
556
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Technical Leader
219
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Quality Engineer
175
salaries
| ₹0 L/yr - ₹0 L/yr |
Devops Engineer
157
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech