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 Referral and was interviewed in Nov 2024. There were 3 interview rounds.
Simple logical based
Palindrome
Reverse a string
The four pillars of Object-Oriented Programming (OOP) are Abstraction, Encapsulation, Inheritance, and Polymorphism.
Abstraction: Hides complex implementation details and only shows the necessary features to the outside world.
Encapsulation: Bundles data and methods that operate on the data into a single unit, preventing direct access to data from outside the class.
Inheritance: Allows a new class to inherit properties an...
I applied via Campus Placement and was interviewed in Aug 2024. There were 3 interview rounds.
Easy to normal level
Array and string questions
TO THE NEW interview questions for popular designations
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
Return the kth element from the end of a linked list
Traverse the linked list to find the length of the list
Calculate the position of the kth element from the beginning
Traverse the list again to find the kth element from the end
Object-oriented programming is a programming paradigm based on the concept of objects, which can contain data and code.
Encapsulation: bundling data and methods that operate on the data into a single unit
Inheritance: creating new classes based on existing classes
Polymorphism: the ability for objects to be treated as instances of their parent class
Get interview-ready with Top TO THE NEW Interview Questions
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
Kubernetes components are essential parts of the Kubernetes architecture that work together to manage containerized applications.
Kubelet: Agent that runs on each node in the cluster and ensures containers are running.
Kube-Proxy: Network proxy that maintains network rules on nodes.
Kubernetes API Server: Component that exposes the Kubernetes API.
Controller Manager: Component that manages different types of controllers.
Sc...
Automate credits of regularly updated VM using scripts
Create a script to automatically update the VM on a regular schedule
Utilize tools like Ansible or Puppet for automation
Set up a cron job to run the script at specified intervals
Ensure proper testing and monitoring of the automation process
Create a docker file to make mongodb available for developers
Use the official MongoDB Docker image as the base image
Expose the default MongoDB port (27017)
Set up any necessary environment variables or configurations
Build the Docker image using the Dockerfile
Run the Docker container with the MongoDB image
I applied via Naukri.com
I applied via Referral and was interviewed in Aug 2024. There were 2 interview rounds.
Basic aptitude way taken into account
Basic data structures and oops concept
Top trending discussions
The duration of TO THE NEW interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 122 interviews
Interview experience
based on 617 reviews
Rating in categories
Senior Software Engineer
603
salaries
| ₹9 L/yr - ₹27.5 L/yr |
Software Engineer
565
salaries
| ₹3.5 L/yr - ₹13.8 L/yr |
Associate Technical Leader
215
salaries
| ₹13.5 L/yr - ₹34.5 L/yr |
Senior Quality Engineer
167
salaries
| ₹7 L/yr - ₹23 L/yr |
Devops Engineer
158
salaries
| ₹4.5 L/yr - ₹13 L/yr |
TCS
Infosys
Wipro
HCLTech