Cognizant Associate Interview Questions, Process, and Tips

Q1. Can you tell me about yourself?
Add your answer
Q2. Why are you pursuing a position in this company with an Electronics and Communications Engineering (ECE) background?
Add your answer

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. Rejoin in cognizant
Add your answer

Q1. Why r u deside Rejoin in cognizant
Add your answer

Q1. Internal implementation of hashmap
Add your answer
Q2. Oops concept basics
Add your answer

Self intro and selenium and testng questions

Q1. Core java related questions
Add your answer
Q2. Previous project details and experience
Add your answer

Q1. Salary negotiation and strength and weakness
Add your answer
Q2. Expectation on my self after 5 years ?
Add your answer

Basic Java and spring framework questions

Q1. Oops concepts are asked
Add your answer
Q2. Project explanation
Add your answer

Q1. Normal salary discussion
Add your answer
Q2. And location discussion
Add your answer