1.Four pillars of OOPS concepts with real time example and have you used in your project or not? 2.Abstract class and interfaces with realtime example 3.Finalise and dispose method 4.Garbage collection in c# 5.Delegates and Events 6.Constant, read-only keyword 7.Solid / design principles 8.Life cycle of MVC 9.Get and post method in MVC 10.ASP.NET vs ASP.NET MVC 11.Partial views and Layouts 12.Bundling and minification in MVC 13.Poco classes 14.ADO.NET and entity Framework diff. 15.Primary key, foreign key, unique key 16.Indexing : cluster index and non cluster index 17.Types of Joins 18.Common table expression (CTE) 19.Magic tables, Temp tables 20.Stored procedure Vs Functions 21.How to optimise the query.

Question

Accepted Answer

Interview questions for Project Associate position covering OOPS concepts, MVC, ADO.NET, and SQL.

Four pillars of OOPS: Abstraction, Encapsulation, Inheritance, Polymorphism
Abstract class: Cannot be instantiated, can have abstract and non-abstract methods
Interfaces: Contract that defines a set of methods, can be implemented by classes
Finalize method: Called by garbage collector before object is destroyed
Dispose method: Used to release unmanaged resources, should be called explicitly
Garbage collection: Automatic memory management in C#, uses mark and sweep algorithm
Delegates: Type-safe function pointers, used for event handling and callbacks
Events: Mechanism for communication between objects, based on delegates
Constant keyword: Value cannot be changed after initialization
Read-only keyword: Value can only be set in constructor
Solid principles: Single Responsibility, Open/Closed, Liskov Substitution, Interface Segregation, Dependency Inversion
MVC lifecycle: Routing, Controller instantiation, Action invocation, View rendering
Get method: Used to retrieve data from server in MVC
Post method: Used to submit data to server in MVC
ASP.NET vs ASP.NET MVC: ASP.NET is a web forms framework, MVC is a pattern for building web applications
Partial views: Reusable views that can be included in other views
Layouts: Define common structure and UI elements for views
Bundling and minification: Combine and compress multiple CSS/JS files for faster loading
POCO classes: Plain Old CLR Objects, used for data transfer in ORM frameworks
ADO.NET vs Entity Framework: ADO.NET is a low-level data access API, EF is an ORM framework
Primary key: Unique identifier for a table row
Foreign key: Links a row in one table to a row in another table
Unique key: Ensures uniqueness of a column or set of columns
Indexing: Improves query performance by creating a data structure for faster lookup
Clustered index: Determines physical order of data in table
Non-clustered index: Separate data structure that points to table data
Types of joins: Inner join, Left join, Right join, Full outer join
Common table expression: Temporary result set that can be used in subsequent queries
Magic tables: Special tables in SQL Server that provide information about changes to data
Temp tables: Temporary tables that exist only for the duration of a session
Stored procedure vs Functions: Stored procedures can modify data, functions cannot
Query optimization: Use indexes, avoid subqueries, limit result set size

Asked in Cognizant

Top Project Associate Interview Questions Asked at Cognizant

Interview Questions Asked to Project Associate at Other Companies

Top Skill-Based Questions for Cognizant Project Associate