TCS Interview Questions and Answers

There are four basic pillars on which OOPS (Object Oriented Programming) is based. These are:

• Abstraction: Abstraction is the process of hiding the details which are not important such as the implementation details and shows only those which are useful. The user can only see the functionality and not the inside working of the system.
• Inheritance: Inheritance is the property of the object-oriented paradigm in which one or more derived class inherits some of the properties of the base class.
• Encapsulation: Encapsulation is the process of wrapping up data in a single unit.
• Polymorphism: It is a property in which a single action can be performed in different ways.

Inheritance is the process of creating new classes from the already existing classes. A coder can create a new class from one or more than one existing class taking some of their capabilities or combining all their capabilities. The already existing classes known as the parent class or the superclass and the class that is created from those parent class i.e., the new class is known as the child class or subclass. The subclass can have its own attributes and characteristics too they are not totally inherited from other classes.

Classes and interfaces are two different concepts which can be understood by the following points :

• By creating an object a class can be instantiated but the interface cannot be instantiated because all the methods in the interface do not perform any actions and are abstract that is why instantiation is not done in the case of interfaces.
• A class keyword is used to declare a class whereas an interface keyword is used to declare an interface.
• A constructor is defined inside the class to declare the fields inside the class whereas no constructor is defined inside the interface as the fields inside it cannot be initialized.

The organization of data in a database in a systematic and efficient manner is known as Normalization. There are two goals of normalization, the first one is to remove the data redundancy( removing duplicate data) and the second one is to ensure that the data dependency makes sense( only storing the data that is relevant in the tables). Both of these goals are very important because if these goals are fulfilled then the database will take less space and it will ensure that only logical data is entered in it.

Through loop, a statement or a block of statements can be executed several times. In a loop we can define the initial value from which the loop should start, the value till we want the loop to run and the increment or decrement counter. The process of the execution of the loop starts with the checking of the value that is going to be its key, we check if it is following the condition that we declared in the statement when we started it. Then the statement inside the loop is executed, the value is incremented or decremented accordingly. And then that value is checked again and the loop ends after the value falls out of the condition of the loop.

Joins: Join is a keyword used in SQL statements to operate two tables based on the relationship between given tables in the database.
Normalization: The process used for organizing data in an efficient way is known as normalization. There are several normal forms in which data is reduced for the minimization of errors. The goal of normalization is to eradicate redundant data and to make sure that data dependencies make sense.
Triggers: A trigger can be defined as an SQL procedure that is used to initiate any action in the database through SQL command.

An Array can be defined as a data type that can store more than one element of the same type. The only condition of the data type Array is that all the elements that are going to be stored in it should be the same, for example, all of them should either be integers, floats, or characters. An Array has three basic parts, the first one is the data type that the array will follow, then the name and then size is defined, the example of how to declare an array is shown below:
int a[10]

There are several types of inheritance namely :

• Single level inheritance
• Multilevel inheritance
• Multiple Inheritance
• Multipath inheritance
• Hybrid inheritance
• Hierarchical inheritance

All the steps involved in the life cycle of the software development phase are known as the Software development life-cycle. It is generally followed by the development team that deals with the development of the software in a particular organization. The steps in the Software development life cycle clearly define the rules and regulations that should be followed to ensure the quality of the software and to efficiently and quickly complete the development process.

There are numerous advantages of DBMS :

• Improvement in data sharing
• Integration of data is much better in DBMS than other processes
• Data inconsistency gets minimized
• DBMS helps in better decision making and a clearer view of elements
• It also contributes to increasing user end productivity.
• Data access gets improved by using DBMS for managing database