Please introduce yourself and explain your ILP training experience in TCS.
Good morning.
My name is Dehra Hatia. I am a graduate from Medicaps University.
I joined TCS as a Ninja and completed my ILP training in Trivandrum.
During ILP, I was trained on the .NET framework, where I learned C#, OOPS concepts, basic [Link], and SQL
fundamentals.
I also have basic knowledge of Java and object-oriented programming.
I am eager to work on real-time projects and improve my technical skills.
Q2. What is .NET and why is it used?
.NET Framework is a development platform created by Microsoft.
It is used to build web applications, desktop applications, and services.
It provides a runtime environment (CLR) and a rich set of libraries which help developers build scalable and
secure applications easily.
Q3. What is CLR and what are its responsibilities?
CLR stands for Common Language Runtime.
It is the execution engine of the .NET framework.
It is responsible for memory management, garbage collection, exception handling, security, and code
execution.
Q4. What is C# and why is it used in .NET?
C# is an object-oriented programming language developed by Microsoft.
It is used within the .NET framework to build web applications, desktop applications, and services.
C# works with the .NET libraries and runtime to develop scalable applications.
Q6. What is the difference between Interface and Abstract Class?
An interface supports multiple inheritance.
A class can implement multiple interfaces.
An interface contains only method declarations, not implementations.
An abstract class can contain both abstract methods and non-abstract methods.
It does not support multiple inheritance.
Abstract methods are declared in the abstract class and implemented in the child class.
Q7. What is [Link] and where is it used?
[Link] is a framework under .NET used to build web applications and web APIs.
It supports the MVC architecture and is used to create RESTful APIs for client-server communication.
If they ask more, you can add:
It helps in building scalable and secure web applications.
Q8. What is MVC architecture? Explain briefly.
MVC stands for Model, View, and Controller.
The Model handles data and business rules,
the View handles the user interface,
and the Controller handles the business logic and user requests.
Q9. What is SQL and why is it used?
SQL stands for Structured Query Language.
It is used to store, retrieve, and manage data in relational databases and handle large datasets efficiently.
Q10. What is the difference between DELETE and TRUNCATE?
DELETE is used to remove specific rows from a table using a WHERE condition and it can be rolled back.
TRUNCATE is used to remove all rows from a table at once and it is faster than DELETE.
If they stop you early, even this is enough:
DELETE removes specific records, TRUNCATE removes all records.
Q11. What is a Primary Key?
A primary key uniquely identifies each record in a table and it cannot be null.
For example, an employee ID is used as a primary key because it is unique for every employee.
Q12. What is a JOIN in SQL? Why do we use it?
JOIN is used to combine data from two or more tables based on a related column.
It helps in retrieving data that is stored across multiple tables.
Q13. What is the difference between INNER JOIN and LEFT JOIN?
An INNER JOIN returns only the rows where there is a match in both tables.
A LEFT JOIN returns all rows from the left table, and the matched rows from the right table. If there is no
match, it still returns all rows from the left table with nulls in place of missing right table data.
The major components .NET framework are given below:
Common Language Runtime(CLR):
o It is an execution engine that runs the code and provides services that make the development
process easier.
o Services provided by CLR are memory management, garbage collection, type safety,
exception handling, security, and thread management. It also makes it easier for designing
the applications and components whose objects interact across the languages.
o The programs written for the .NET Framework are executed by the CLR regardless of
programming language. Every .NET Framework version is having CLR.
Framework Class Library(FCL):
o It has pre-defined methods and properties to implement common and complex functions
that can be used by .NET applications. It will also provide types for dates, strings, numbers,
etc.
o This class library includes APIs for database connection, file reading and writing, drawing, etc.
9. What is the difference between managed and unmanaged code?
The main difference between managed and unmanaged code is listed below:
Managed Code Unmanaged Code
It is managed by CLR. It is not managed by CLR.
Does not require a .NET framework for the
.NET framework is a must for execution.
execution.
Memory management is done through Runtime environment takes care of memory
garbage collection. management.
4. What is CTS?
CTS stands for Common Type System. It follows a set of structured rules according to which a
data type should be declared and used in the program code. It is used to describe all the
data types that are going to be used in the application.
We can create our own classes and functions by following the rules in the CTS. It helps in
calling the data type declared in one programming language by other programming
languages
Differences Between .NET Core and .NET Framework
Last Updated : 17 Jul, 2023
.NET Core is a free open source, a general-purpose development platform for developing
modern cloud-based software applications on Windows, Linux, and macOS operating
systems. It operates across several platforms and has been revamped to make .NET fast,
scalable, and modern. .NET Core is one of Microsoft's big contributions and released under
the MIT License. It offers the following features:
Cross-Platform
Open Source
High Performance
Multiple environments and development mode etc.
.NET is a software framework that is designed and developed by Microsoft. The first version
of the .Net framework was 1.0 which came in the year 2002. In easy words, it is a virtual
machine for compiling and executing programs written in different languages like C#, [Link],
etc. It is used to develop form-based applications, web-based applications, and web services.
There is a variety of programming languages available on the .Net platform, [Link], and C#
being the most common ones. It is used to build applications for Windows, mobile, web, etc.
It provides a lot of functionalities and also supports industry standards.