Cognizant Technical Lead Interview Questions, Process, and Tips

Real-time scenarios for OOPS concepts include modeling a car as an object with properties and methods.

• Modeling a car as an object with properties like color, speed, and methods like accelerate, brake

• Inheritance can be seen in a vehicle hierarchy with classes like Car, Truck, Motorcycle

• Polymorphism can be demonstrated with a Drive method that behaves differently for each vehicle type

3-tier architecture separates presentation, logic, and data layers. ASP.NET page life cycle includes events from initialization to rendering.

• 3-tier architecture divides an application into presentation, logic, and data layers for better scalability and maintainability

• ASP.NET page life cycle includes events like Page_Init, Page_Load, and Page_PreRender for managing page state and rendering

• Example: Presentation layer can...read more

Use a common table expression (CTE) with ROW_NUMBER() function to delete duplicate records.

• Use a CTE to assign a row number to each record partitioned by the columns that define duplicates

• Delete records where the row number is greater than 1

• Example: WITH CTE AS (SELECT *, ROW_NUMBER() OVER (PARTITION BY column1, column2 ORDER BY column1) AS rn FROM table_name) DELETE FROM CTE WHERE rn > 1

CTE stands for Common Table Expressions. It is a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.

• CTE is defined using the WITH keyword in SQL.

• It helps in breaking down complex queries into simpler, more manageable parts.

• CTEs can reference themselves recursively, making them useful for hierarchical data.

• They are especially useful for avoiding code duplication and improvin...read more

I am currently earning $100,000 per year.

• My current annual salary is $100,000.

• I am earning $8,333.33 per month.

• I receive a monthly salary of $8,333.33.

• My current compensation package is $100,000 per annum.