Cognizant Associate Interview Questions, Process, and Tips

Q1. Difference between clustered and non clustered index
Ans. 
Clustered index physically reorders the data on disk, while non-clustered index creates a separate structure.
• Clustered index determines the physical order of data rows in a table, while non-clustered index does not.

• Clustered index is faster for retrieval of large ranges of data, while non-clustered index is faster for retrieval of individual rows.

• A table can have only one clustered index, but multiple non-clustered ind...read more
Answered by AI
Add your answer
Q2. Duplicate records removal using sql
Ans. 
Use SQL queries to remove duplicate records from a database table.
• Use the DISTINCT keyword in SELECT statement to retrieve unique records.

• Use the GROUP BY clause to group records based on specific columns.

• Use the ROW_NUMBER() function to assign a unique row number to each record and then filter out duplicates.
Answered by AI
Add your answer

Q1. How to handle leave request
Ans. 
Handle leave requests by following company policy, communicating with team members, and ensuring coverage.
• Refer to company policy for leave request procedures

• Communicate with team members to ensure coverage during absence

• Document leave requests and approvals for record keeping
Answered by AI
Add your answer
Q2. How to deliver projects on time
Ans. 
To deliver projects on time, it is important to set clear timelines, prioritize tasks, communicate effectively, and regularly monitor progress.
• Set clear project timelines and deadlines

• Prioritize tasks based on importance and urgency

• Communicate effectively with team members and stakeholders

• Regularly monitor progress and make adjustments as needed
Answered by AI
Add your answer

Q1. Java new features in 8
Ans. 
Java 8 introduced several new features including lambda expressions, functional interfaces, streams, and default methods.
• Lambda expressions allow you to treat functionality as a method argument.

• Functional interfaces have a single abstract method and can be used with lambda expressions.

• Streams provide a way to work with sequences of elements and perform operations on them.

• Default methods allow interfaces to have method ...read more
Answered by AI
Add your answer
Q2. Difficulties faced in the current/previous project & how we resolved it
Ans. 
We faced challenges with communication and conflicting priorities, resolved through regular team meetings and clear task delegation.
• Lack of clear communication among team members

• Conflicting priorities leading to delays in project timeline

• Resolved by scheduling regular team meetings to discuss progress and issues

• Clear task delegation to ensure everyone knows their responsibilities
Answered by AI
Add your answer
Q3. What is OOPS
Ans. 
OOPS stands for Object-Oriented Programming System. It is a programming paradigm based on the concept of objects.
• OOPS focuses on creating objects that contain data and methods to manipulate that data.

• Encapsulation, inheritance, and polymorphism are key principles of OOPS.

• Examples of OOPS languages include Java, C++, and Python.
Answered by AI
Add your answer
Q4. What is Functional programming
Ans. 
Functional programming is a programming paradigm that treats computation as the evaluation of mathematical functions and avoids changing state and mutable data.
• Focuses on pure functions that do not have side effects

• Emphasizes immutability and avoids changing state

• Uses higher-order functions and function composition

• Commonly used languages include Haskell, Scala, and Clojure
Answered by AI
Add your answer
Q5. Difference between OOPS and functional programming
Ans. 
OOPS focuses on objects and classes, while functional programming focuses on functions and immutability.
• OOPS is based on the concept of objects and classes, allowing for encapsulation, inheritance, and polymorphism.

• Functional programming emphasizes on functions as first-class citizens, immutability, and avoiding side effects.

• OOPS is more suitable for complex, real-world applications with changing state, while functiona...read more
Answered by AI
Add your answer
Q6. Which framework I worked in Java
Ans. 
I have worked with the Spring framework in Java.
• Utilized Spring MVC for web development

• Implemented dependency injection with Spring IoC container

• Integrated Spring Security for authentication and authorization
Answered by AI
Add your answer
Q7. What all are the annotations that we use in Spring Boot & it's usage
Ans. 
Some common annotations used in Spring Boot are @RestController, @Autowired, @RequestMapping, @Service, @Component, @Repository.
• @RestController - Used to define a controller class in Spring MVC.

• @Autowired - Used for automatic dependency injection.

• @RequestMapping - Used to map web requests to specific handler methods.

• @Service - Indicates that a class is a service.

• @Component - Indicates that a class is a Spring component...read more
Answered by AI
Add your answer

Q1. Tell me about yourself, work experience & education
Ans. 
I am a dedicated professional with a strong educational background and diverse work experience.
• I have a Bachelor's degree in Business Administration from XYZ University.

• I have worked in various roles in marketing, sales, and customer service.

• I am proficient in Microsoft Office Suite and have excellent communication skills.

• I am a quick learner and thrive in fast-paced environments.

• I am passionate about continuous learni
Answered by AI
Add your answer

Q1. What is pure vs impure pipes
Add your answer
Q2. Generics in typescript
Add your answer
Q3. Rxjs Operators- scenario based
Add your answer
Q4. Dependency injection in angular
Add your answer

Asked reasoning question and more

Q1. Introduction of yourself and more
Add your answer
Q2. Explain opps concept in java
Add your answer