Cognizant Programmer Analyst Interview Questions and Answers for Freshers

First round is aptitude

Second was coding then after technical interview

Q1. One aptitude Question
Add your answer
Q2. One simple coding question like find the frequency of arrays
Ans. 
This task involves counting the frequency of each string in an array and returning the results in a structured format.
• Use a dictionary to store the frequency of each string.

• Iterate through the array and update the count in the dictionary.

• Example: For input ['apple', 'banana', 'apple'], output should be {'apple': 2, 'banana': 1}.
Answered by AI
Add your answer

Repeated questions have been asked.

Basic Questions Were Asked.

Q1. What is sap abap
Ans. 
SAP ABAP is a high-level programming language used for developing applications on the SAP platform.
• ABAP stands for Advanced Business Application Programming.

• It is primarily used for developing business applications in SAP environments.

• ABAP programs can be executed on the SAP NetWeaver Application Server.

• Common use cases include report generation, data manipulation, and interface development.

• Example: Creating custom rep...read more
Answered by AI
Add your answer
Q2. What is workflow
Ans. 
Workflow is a sequence of tasks or processes that define how work is completed within an organization.
• Defines the steps needed to complete a task, e.g., processing a loan application.

• Can be automated using software tools, like project management systems.

• Involves roles and responsibilities, ensuring accountability, e.g., who approves a document.

• Can be visualized using flowcharts to illustrate the process, e.g., customer...read more
Answered by AI
Add your answer

Q1. Example or your leadership quality
Add your answer
Q2. If your manager is on leave and you have an critical business issue . Even your manager is out of office and not able to reach out to him through mobile. What will you do?
Add your answer

HACKERRANK TEST WAS CONDUCTED FOR TESTING THE KNOWLEDGE IN REACT.JS AS I BELONG TO THAT FIELD.

Q1. What project you were in ?
Add your answer
Q2. What was your day to day role in that project?
Add your answer
Q3. Two defined table and fetching data is done one table has 20 records of 20 students another table has 10 student information if i want to pick the common record how to pick?
Ans. 
Use SQL JOIN to fetch common records from two tables.
• Use SQL JOIN to combine the two tables based on a common column (e.g. student ID).

• Select the columns you want to retrieve from both tables.

• Use the WHERE clause to filter out the records that are common between the two tables.
Answered by AI
Add your answer
Q4. Difference between sql and sql server?
Ans. 
SQL is a language used to manage databases, while SQL Server is a Microsoft product that includes a database management system.
• SQL is a language used to interact with databases, while SQL Server is a Microsoft product that includes a database management system.

• SQL can be used with various database management systems like MySQL, Oracle, etc., while SQL Server is specific to Microsoft.

• SQL is a standard language for query...read more
Answered by AI
Add your answer
Q5. Question related to Joins?
Add your answer
Q6. If i want to select uncommon records which does not match how to pick?
Ans. 
To select uncommon records that do not match, use the NOT IN or NOT EXISTS clause in SQL.
• Use the NOT IN clause to select records that do not match a specific list of values.

• Use the NOT EXISTS clause to select records that do not have a matching record in a subquery.

• Example: SELECT * FROM table_name WHERE column_name NOT IN (value1, value2);

• Example: SELECT * FROM table1 WHERE NOT EXISTS (SELECT * FROM table2 WHERE table...read more
Answered by AI
Add your answer
Q7. Explain react in website making?
Ans. 
React is a JavaScript library for building user interfaces.
• React allows developers to create reusable UI components.

• It uses a virtual DOM for efficient rendering.

• React can be used to build single-page applications.

• React is maintained by Facebook and a community of developers.

• React can be combined with other libraries like Redux for state management.
Answered by AI
Add your answer
Q8. How to add moving images in flipkart?

Ans. 

Moving images can be added in Flipkart by using HTML and CSS animations.

• Use HTML tag to insert the image

• Apply CSS animations to create the moving effect

• Use keyframes to define the animation behavior

Add your answer