Cognizant Programmer Analyst Interview Questions, Process, and Tips

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
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