TCS Interview Questions, Process, and Tips

C is a procedural language while Java is an object-oriented language.

• C is compiled while Java is interpreted

• Java has automatic garbage collection while C requires manual memory management

• Java has platform independence while C is platform dependent

• Java has built-in exception handling while C does not

• Java has a larger standard library than C

MVC stands for Model-View-Controller. It is a software design pattern used to separate an application's concerns.

• Model represents the data and business logic

• View displays the data to the user

• Controller handles user input and updates the model and view accordingly

• MVC promotes separation of concerns and modularity

• Examples include Ruby on Rails, ASP.NET MVC, and Spring MVC

There are two types of joining in SQL: Inner Join and Outer Join.

• Inner Join returns only the matching rows from both tables.

• Outer Join returns all the rows from both tables, with NULL values for non-matching rows.

• Outer Join has three sub-types: Left Join, Right Join, and Full Outer Join.

Primary key uniquely identifies a record in a table, while foreign key refers to a field in another table.

• Primary key is unique and cannot be null

• Foreign key is used to establish a relationship between two tables

• Primary key can be used as a foreign key in another table

• Foreign key can have null values

• Example: CustomerID in Orders table is a foreign key referencing CustomerID in Customers table

Oops stands for Object-Oriented Programming System. It is a programming paradigm based on objects.

• Oops is a programming paradigm that focuses on objects and their interactions.

• It allows for encapsulation, inheritance, and polymorphism.

• Encapsulation refers to the hiding of implementation details within an object.

• Inheritance allows for the creation of new classes based on existing ones.

• Polymorphism allows for the use of ...read more