i
TO THE NEW
Filter interviews by
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
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 3 interview rounds.
posted on 16 Jul 2024
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
Identify potential causes through system analysis, logs, and monitoring tools. Implement troubleshooting steps to resolve the issue.
Analyze system performance metrics such as CPU usage, memory usage, disk I/O, and network traffic to identify bottlenecks.
Check system logs for any error messages or warnings that could indicate the source of the slowness.
Review application logs to see if there are any specific requests or...
I would analyze the thread dump to identify any bottlenecks or issues causing the system slowness.
Identify any threads that are in a blocked or waiting state
Look for any threads consuming excessive CPU or memory
Check for any deadlocks or resource contention issues
Analyze the stack traces to pinpoint the root cause of the slowness
posted on 8 Jan 2025
I was interviewed in Oct 2023.
Write a program on priority queue
I applied via Recruitment Consulltant and was interviewed in Sep 2023. There were 2 interview rounds.
Builder design pattern is a creational design pattern used to construct complex objects step by step.
Builder pattern separates the construction of a complex object from its representation.
It allows the same construction process to create different representations of the object.
Useful when there are multiple ways to construct an object or when the object creation process is complex.
Example: StringBuilder in Java allows ...
JOIN query to retrieve country and employee name
Use JOIN keyword to combine data from multiple tables
Specify the columns to select from each table
Use ON keyword to specify the relationship between the tables
I applied via LinkedIn and was interviewed in Jun 2023. There were 4 interview rounds.
Use lambda function to print greater number
Define a lambda function that takes two parameters
Use the max() function inside the lambda to compare the two numbers
Call the lambda function with two numbers to print the greater one
OOPs concepts refer to Object-Oriented Programming principles like inheritance, encapsulation, polymorphism, and abstraction.
Inheritance: Allows a class to inherit properties and behavior from another class.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Polymorphism: Ability to present the same interface for different data types.
Abstraction: Hiding the complex implementation detail
Fibonacci series code in iterative and recursive methods
Iterative method: Use a loop to calculate Fibonacci numbers
Recursive method: Define a function that calls itself to calculate Fibonacci numbers
Example for iterative method: int fib(int n) { int a = 0, b = 1, c; for(int i = 2; i <= n; i++) { c = a + b; a = b; b = c; } return b; }
Example for recursive method: int fib(int n) { if(n <= 1) return n; return fib(n-1) + f
Use two threads to print numbers 1-10 in correct order
Create two threads, one for printing odd numbers and one for printing even numbers
Use synchronization mechanisms like mutex or semaphore to ensure correct order
Example: Thread 1 prints 1, 3, 5, 7, 9 and Thread 2 prints 2, 4, 6, 8, 10
Unit testing in C++ involves writing test cases for individual units of code to ensure they work as expected.
Use a unit testing framework like Google Test or Catch2 to write and run test cases
Create separate test files for each unit of code being tested
Use assertions to check the expected behavior of the code under test
Mock dependencies or use dependency injection to isolate units for testing
Run tests regularly to catc
My salary expectations are based on my experience, skills, and the market rate for the position.
Consider my years of experience in the industry
Research the average salary range for similar positions in the market
Factor in the cost of living in the location of the job
Be open to negotiation based on the overall compensation package offered
1 Interview rounds
based on 28 reviews
Rating in categories
Senior Software Engineer
596
salaries
| ₹9 L/yr - ₹27.5 L/yr |
Software Engineer
570
salaries
| ₹3.5 L/yr - ₹13.8 L/yr |
Associate Technical Leader
207
salaries
| ₹13.8 L/yr - ₹35.4 L/yr |
Senior Quality Engineer
168
salaries
| ₹7 L/yr - ₹22.5 L/yr |
Devops Engineer
157
salaries
| ₹4.5 L/yr - ₹14.5 L/yr |
TCS
Infosys
Wipro
HCLTech