TCS Full Stack Software Developer Interview Questions and Answers

Stored procedure is a precompiled collection of SQL statements that can be executed by calling the procedure name.

• Stored procedures are stored in the database and can be reused multiple times.

• They can accept input parameters and return output parameters.

• They help improve performance by reducing network traffic and improving security.

• Examples: sp_GetCustomerDetails, sp_InsertEmployee

Abstract class is a class that cannot be instantiated and is used as a blueprint for other classes to inherit from.

• Cannot be instantiated directly

• Can have abstract methods that must be implemented by subclasses

• Can have non-abstract methods that can be inherited by subclasses

• Used to define common behavior for subclasses

Access modifiers are keywords in programming languages that define the accessibility of classes, methods, and variables.

• Access modifiers control the visibility and accessibility of classes, methods, and variables in a program.

• Common access modifiers include public, private, protected, and default (package-private).

• Public access modifier allows access from any other class.

• Private access modifier restricts access to only within the same class.

• Protected access modifier allows ac...read more

A functional interface is an interface that contains only one abstract method.

• Functional interfaces can have multiple default or static methods, but only one abstract method.

• Functional interfaces are used in lambda expressions and method references.

• Examples of functional interfaces in Java include Runnable, Callable, and Comparator.

Method overloading is when multiple methods in a class have the same name but different parameters.

• Allows multiple methods with the same name but different parameters to be defined in a class

• The compiler determines which method to call based on the number and type of arguments passed

• Example: having multiple 'calculate' methods in a class with different parameter types like int, double, etc.

Oops in Java stands for Object-Oriented Programming. It is a programming paradigm based on the concept of objects.

• Oops in Java focuses on creating objects that interact with each other to solve a problem

• It involves concepts like classes, objects, inheritance, polymorphism, and encapsulation

• Example: Creating a class 'Car' with properties like 'make', 'model', and methods like 'drive', 'stop'