i
Tech Mahindra
Filter interviews by
To create an Outlook PST file, you can use the Import and Export Wizard within Outlook.
Open Outlook and go to File > Open & Export > Import/Export.
Select 'Export to a file' and click Next.
Choose 'Outlook Data File (.pst)' and click Next.
Select the folder you want to export and choose a location to save the PST file.
Set any options you prefer and click Finish to create the PST file.
I applied via Naukri.com and was interviewed in Jul 2022. There was 1 interview round.
Indexes are used to improve database performance. Clustered indexes determine the physical order of data, while non-clustered indexes do not.
Indexes are used to speed up data retrieval operations in a database.
Clustered indexes determine the physical order of data in a table, while non-clustered indexes do not.
A table can have only one clustered index, but multiple non-clustered indexes.
Clustered indexes are generally ...
Query to delete duplicate rows from a table
Use GROUP BY clause to group the rows by their unique values
Use HAVING clause to filter out the groups with count greater than 1
Use DELETE statement to delete the duplicate rows
Singleton pattern restricts the instantiation of a class to a single instance and provides a global point of access to it.
Create a private constructor to restrict instantiation of the class
Create a private static instance of the class
Create a public static method to access the instance
Ensure thread safety if necessary
Examples: Database connection, Logger, Configuration settings
Handle exceptions in stored procedures by using TRY-CATCH blocks.
Use TRY-CATCH blocks to catch and handle exceptions
Log the error message and severity level
Rollback the transaction if necessary
Rethrow the error if it cannot be handled
Use RAISERROR to raise custom error messages
SOLID principles are a set of five design principles that help in creating maintainable and scalable software.
S - Single Responsibility Principle: A class should have only one reason to change.
O - Open-Closed Principle: Software entities should be open for extension but closed for modification.
L - Liskov Substitution Principle: Subtypes should be substitutable for their base types.
I - Interface Segregation Principle: C...
throw is used to throw an exception while throw exception is used to throw a specific exception.
throw is used to throw any type of exception while throw exception is used to throw a specific type of exception.
throw exception is followed by the type of exception that needs to be thrown.
throw can be used to throw any object while throw exception can only be used to throw an exception object.
Example: throw new Exception("
I applied via Naukri.com and was interviewed in Jun 2022. There were 2 interview rounds.
Abstraction is a concept of hiding implementation details while interface is a contract that defines the behavior of a class.
Abstraction is achieved through abstract classes and methods
Interface is a collection of abstract methods
Abstraction is used for reducing complexity and increasing efficiency
Interface is used for achieving multiple inheritance and loose coupling
Abstraction is a way of achieving data abstraction w...
Merit and demerit of Machine learning ?
General Aptitude and reasoning
Normalisation is the process of organizing data in a database to reduce redundancy and improve data integrity.
It involves dividing larger tables into smaller ones and defining relationships between them.
Normalization helps to eliminate data inconsistencies and anomalies.
There are different levels of normalization, such as first normal form (1NF), second normal form (2NF), and so on.
Normalization can improve database pe...
Polymorphism is the ability of an object to take on many forms.
It allows objects of different classes to be treated as if they were objects of the same class.
It is achieved through method overriding and method overloading.
Example: A shape class can have multiple subclasses like circle, square, etc. and all can be treated as shapes.
Example: A method can take an object of a parent class as a parameter and it can accept a
Stack is a data structure that follows LIFO. Pre and post tree formation are methods of traversing a tree.
Stack is used for backtracking, undoing, and recursion.
Pre-order traversal visits the root node first, then left subtree, then right subtree.
Post-order traversal visits the left subtree, then right subtree, then root node.
I applied via Company Website and was interviewed in Jul 2022. There were 3 interview rounds.
It's a mental ability test
How to communicate other person
Java, micro service, spring boot
A prime number is a positive integer greater than 1 that has no positive integer divisors other than 1 and itself.
Prime numbers are only divisible by 1 and themselves
Examples of prime numbers include 2, 3, 5, 7, 11, 13, 17, 19, 23, 29, 31, 37, 41, 43, 47, 53, 59, 61, 67, 71, 73, 79, 83, 89, and 97
Prime numbers are important in cryptography and number theory
Code to check if a number is prime or not.
A prime number is only divisible by 1 and itself.
Start checking from 2 up to the square root of the number.
If the number is divisible by any number in the range, it's not prime.
Otherwise, it's prime.
What is the average age of a group of people with ages ranging from 20 to 60?
Add up all the ages and divide by the number of people in the group
The age range is 40 years
Assuming an equal distribution of ages, the average age would be 40
I applied via campus placement at SSN College of Engineering, Chennai and was interviewed in Apr 2021. There were 5 interview rounds.
Yes, GD-one time use plastic should be banned.
One-time use plastic is harmful to the environment and wildlife.
Alternatives like reusable bags and containers are readily available.
Many countries and cities have already implemented bans on single-use plastics.
Reducing plastic waste is crucial for the health of our planet.
I applied via Freshervoice, apuzz.com and was interviewed in Nov 2020. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Dec 2019. There were 3 interview rounds.
A controller is a component that handles incoming requests and returns a response, while a REST controller specifically handles RESTful requests.
A controller is responsible for handling various types of requests, such as HTTP, WebSocket, etc.
A REST controller is a type of controller that specifically handles RESTful requests, which follow the principles of Representational State Transfer (REST).
REST controllers typical...
A functional interface is an interface that has only one abstract method.
Functional interfaces are used in lambda expressions and method references.
They can have default methods and static methods.
Examples include Runnable, Comparator, and Function interfaces.
Functional interfaces can be annotated with @FunctionalInterface annotation.
Lambda expression is a concise way to represent anonymous functions in programming languages.
Lambda expressions are commonly used in functional programming languages.
They can be used to create functions on the fly without having to define them explicitly.
Lambda expressions are often used in higher-order functions, such as map, filter, and reduce.
They can also be used to create closures, which are functions that capture...
Exception propagation is the process of passing an exception up the call stack to be handled by a higher-level method.
Exceptions are thrown when an error occurs in a method.
If the exception is not caught and handled within the method, it is propagated up the call stack.
Each method in the call stack has the option to catch and handle the exception or propagate it further up.
If the exception reaches the top of the call s...
get() method returns null if the object is not found in the cache or database, while load() method throws an exception.
get() method is eager loading while load() method is lazy loading.
get() method returns the object from the database or cache while load() method returns a proxy object.
get() method is slower than load() method.
get() method is used when we are not sure if the object exists in the database or cache while...
Method overriding is when a subclass provides its own implementation of a method that is already defined in its superclass.
Method overriding is used to achieve runtime polymorphism.
The method signature (name, parameters, return type) must be the same in both the superclass and subclass.
The access level of the overriding method cannot be more restrictive than the overridden method.
Example: class Dog extends Animal { pub...
IOC and DI are design patterns used in Spring framework for loose coupling and dependency injection.
IOC (Inversion of Control) is a design pattern where the control of object creation and lifecycle is handed over to a container or framework.
DI (Dependency Injection) is a design pattern where the dependencies of an object are injected into it by an external entity, rather than the object creating them itself.
Spring fram...
HashMap is a data structure that stores key-value pairs and uses hashing to retrieve values quickly.
HashMap uses an array of buckets to store key-value pairs
Each bucket contains a linked list of entries with the same hash code
When a key-value pair is added, its hash code is used to determine the bucket and added to the linked list
When a value is retrieved, its hash code is used to find the bucket and search the linked ...
Spring Boot provides rapid application development and microservices architecture.
Easy configuration and setup
Embedded servers for faster development
Auto-configuration of dependencies
Supports multiple data sources
Actuator for monitoring and managing applications
Simplifies development of RESTful web services
Enables building of microservices architecture
Provides a wide range of plugins and extensions
Reduces boilerplate c
based on 1 interview
Interview experience
based on 8 reviews
Rating in categories
Software Engineer
26.3k
salaries
| ₹2 L/yr - ₹9.1 L/yr |
Senior Software Engineer
21.3k
salaries
| ₹5.5 L/yr - ₹23.1 L/yr |
Technical Lead
11.6k
salaries
| ₹9.3 L/yr - ₹37 L/yr |
Associate Software Engineer
5.4k
salaries
| ₹1.8 L/yr - ₹6 L/yr |
Team Lead
4.9k
salaries
| ₹5.2 L/yr - ₹17 L/yr |
Infosys
Cognizant
Accenture
Wipro