Tech mahindra technical interview questions for freshers

Tech Mahindra technical interview questions for freshers

Tech Mahindra is an Indian multinational information technology services and consulting company. The Mahindra Group company is headquartered in Pune and has its registered office in Mumbai. Tech Mahindra has more than 146,000 employees in 90 countries. The company was ranked 5th among IT companies in India and 47th in Fortune India 500 in 2019.

Tech Mahindra

Note

Technical Interview is the fourth round of Tech Mahindra Hiring

You Need Strong Internet Connectivity like good Wi-Fi / Broadband service.

Check System is working properly or not and install all the meet software for the interview e.g. MS Teams

Better Background No background noise & headphones or headset for better audio.

Questions & Answers

Tell me about yourself ?

Thank you for giving me the opportunity to introduce myself. I am Your Name, I belong to District State Name. Currently, I am pursuing a Degree Name.

Talking about your Technical Achievements e.g. Hackathon and Other interests.

Now mention the Programming skills you know and technology.

Mention Strengths and Weakness.

Mention your hobbies e.g. Volunteering, Reading

Which programming language do you know?

Tell clearly about the programming language you know e.g. JAVA, C, C++, Python or JavaScript

Difference between C++ and C# ?

Aspect	C++	C#
Syntax	Syntax heavily influenced by C	Syntax similar to Java, with C-like features
Memory Management	Manual memory management (using new, delete)	Automatic memory management with garbage collection
Platform and Ecosystem	Platform-independent, used for system-level software, games, and embedded systems	Primarily used for Windows applications, web development (with ASP.NET), and game development (with Unity)
Development Environment	Relies on various compilers and IDEs like Visual Studio, GCC, Clang	Heavily integrated with Microsoft's Visual Studio IDE
Language Feature	Pointers, multiple inheritance, operator overloading, manual memory management	Automatic memory management, properties, events, delegates, LINQ
Primary Use Cases	Performance-critical applications, system-level software, game engines	Rapid application development, Windows applications, web development, game development (with Unity)

Difference between JAVA and C++ ?

Aspect	JAVA	C++
Syntax	Syntax influenced by C and C++, but with simplified features and additional constructs	Syntax influenced by C, supports low-level memory manipulation
Memory Management	Automatic memory management through garbage collection	Manual memory management using new and delete operators
Platform Independence	Write once, run anywhere (WORA) principle, platform-independent bytecode executed by Java Virtual Machine (JVM)	Platform-dependent, native code executed directly by the operating system
Development Environment	Supported by various IDEs like Eclipse, IntelliJ IDEA, and NetBeans	Relies on compilers and IDEs such as Visual Studio, GCC, and Clang
Language Features	Object-oriented programming (OOP), automatic memory management, exception handling, multithreading	Supports OOP, templates, operator overloading, multiple inheritance, pointers
Standard Libraries	Rich set of standard libraries and APIs (Application Programming Interfaces) provided by Java Development Kit (JDK)	Standard Template Library (STL) and Standard C++ Library (STL) offer essential data structures and algorithms
Primary Use Cases	Cross-platform desktop and web applications, enterprise software, Android app development	System-level programming, game development, performance-critical applications, embedded systems

Do you know about OOPs, what is the four pilers of OOPs ?

OOP, or object-oriented programming, is a programming paradigm that organizes software design around objects that encapsulate data and behavior, promoting modularity, reusability, and maintainability in software development.

Encapsulation: Encapsulation is the aggregation of processing data and methods. data into a single unit, improving information security and modularity. Example: The "Auto" class encapsulates properties such as speed and methods such as accelerate().

Inheritance: Inheritance allows a class to inherit properties and methods from another class, promoting code reusability and hierarchical order. Example: class "SUV" inherits properties like maxSpeed from superclass "vehicle". Example: The same "drive()" method can be used to access different types of vehicle objects, such as "car" or "truck".

Abstraction: Abstraction means modeling the real entities in simplified representations, hiding . unnecessary details and focus on important features. Example: The "Animal" class summarizes certain details about different animal species and provides a common structure for behaviors such as eat() and sleep().

Polymorphism: Polymorphism allows objects of different classes to be treated as objects of a common superclass, which facilitates dynamic method assignment. Example: The same "drive()" method can be used to drive objects of different types of vehicles, such as "Car" or "Truck".

What is DBMS & RDBMS ?

DBMS (Database Management System): It is a software system that allows users to define, create, maintain and control access to databases. It provides functions such as data storage, retrieval, manipulation and protection.

RDBMS (Relational Database Management System): This is a type of DBMS that organizes data into tables with rows and columns and enforces relationships between tables using keys. RDBMSs use Structured Query Language (SQL) to manage and query data. For example, MySQL, PostgreSQL and Oracle..

What is SQL and NO-SQL ?

SQL (Structured Query Language): It is a standard language for managing and manipulating relational databases. SQL allows users to perform tasks such as querying data, updating records, defining schemas, and managing access rights in relational database management systems (RDBMS).

NoSQL (not just SQL): This is comprehensive. field a category of database management systems that use non-relational data models. NoSQL databases are designed to handle large amounts of unstructured, semi-structured, or rapidly changing data. They provide flexibility, scalability and high performance for specific use cases such as big data, real-time analytics and distributed systems. Examples include MongoDB, Cassandra and Redis.

What is Primary Key, Foreign key and Super key ?

Primary Key: This is a unique identifier for each record in a database table. This ensures that each table row is unique and serves as a reference point for relationships with other tables. Primary keys must be unique and must not contain null values.

Foreign key: This is a column or combination of columns in a database table that forms a link between two tables. A foreign key in one table is related to the primary key in another table, creating a relationship between the two tables. This ensures referential integrity and helps maintain data consistency.

Super key: This is a set of one or more attributes that together identify each record in a table. A super key can contain more attributes than are necessary to uniquely identify records, making it a superset of candidate keys. This is the basis for defining candidate keys, one of which is chosen as the primary key.

What is Constraints ?

Database constraints are rules that impose certain conditions or restrictions on data stored in tables. They help maintain data integrity and consistency by preventing incorrect or inconsistent data from being added, updated or deleted. There are several types of constraints commonly used in database management systems:1.

Primary Key Constraint: ensures that each record in the table has a unique identifier. This prevents duplicate or null values in the specified columns and usually specifies the primary key of the table.2.

Foreign Key Constraint: Creates a relationship between two tables, enforcing referential integrity. This ensures that the values of a column (foreign key) in one table match the values of a primary key column in another table. This helps maintain data consistency between related tables.

Unique constraint: ensures that all values in a given column or combination of columns are unique, similar to a primary key constraint. Unlike a primary key, it allows null values and a table can have multiple unique constraints.

Check Constraint: specifies a condition that must be fulfilled on each row of the table. This limits the range of allowed values for certain columns, ensuring that data is correct and consistent.

Non-null Constraint: prevents null values from being inserted into a column by requiring that each row have a non-null value for the specified column.

Difference between SQL Delete Drop & Truncate ?

In SQL, commands "DELETE", "DROP" and "TUNCATE" are used to manipulate database objects, but they have different purpose and operation:

DELETE:

Purpose: DELETE command is used to delete one or more rows . . . of the table based on a certain condition.

Behavior: The DELETE function deletes certain rows from the table and leaves the table structure intact. This is a Data Manipulation Language (DML) operation and can be canceled by event if necessary.

Usage: The DELETE operation is usually used when you want to selectively delete rows from a table while preserving the structure and other data of the table.

DROP :

Purpose: DROP- i is used to drop database objects such as tables, views, indexes, or sequences from the database.

Behavior: The DROP operation removes the entire object from the database, including all associated data and dependent objects. . This is a Data Definition Language (DDL) operation and cannot be undone.

Usage: The DROP operation is typically used when you want to permanently remove a table or other database object from the database schema.

TRUNCATE:

Purpose: TRUNCATE is used to quickly delete all rows from a table, without recording individual rows.

Behavior: The TRUNCATE function deletes all rows from a table while preserving the table's structure, column definitions, and associated metadata. This is a DDL operation and cannot be undone. TRUNCATE is usually faster than DELETE for large tables because it unloads data pages.

Usage: TRUNCATE is often used when you want to effectively delete all data from a table, especially in situations where you want to restore the contents of the table by dropping it. and not recreating it. .

In Short:

DELETE: Deletes certain rows from a table based on a condition, can be rolled back and preserves the table structure.

DROP: Permanently deletes entire database objects, including all associated data and dependent objects, cannot be rolled back.

TRUNCATE : Removes all rows from a table quickly, cannot be undone, and preserves table structure and metadata.

Can you explain the concept of RESTful APIs?

RESTful APIs are a type of web service that uses standard HTTP methods (GET, POST, PUT, DELETE) to interact with resources represented by unique URIs. They follow the principles of the REST architecture, promoting stateless communication, uniform interfaces, and resource-based communication. This approach enables scalable, flexible and interoperable communication between clients and servers over the network..

What is Machine Learning ?

Machine learning is a branch of artificial intelligence (AI) that focuses on creating algorithms and models that allow computers to learn from data and make predictions or decisions without special programming. It develops algorithms that can identify patterns in data, learn from past experiences and improve their performance over time. In short, it's a way for computers to learn from data and evolve without human intervention..

What is Dev-Ops ?

DevOps is a software development approach that aims to improve collaboration between software development (Dev) and IT operations (Ops) teams by automating and streamlining the process of software delivery and infrastructure change. This includes practices such as continuous integration, continuous delivery, and infrastructure-as-code that enable faster and more reliable software and development. In short, DevOps breaks down silos between development and operations teams to achieve faster and more efficient delivery of software..

Answers tips and tricks

Be confident and maintain eye contact

Start with the technical definition and try to cover the answer in short.

Include real-life examples while explaining technical terms.

Tech mahindra technical interview questions for freshers