Cognizant Product Consultant Interview Questions and Answers

Q1. Tell me about yourself
Ans. 
Experienced product manager with a background in tech and a passion for creating innovative solutions.
• Over 5 years of experience in product management

• Strong background in technology and software development

• Proven track record of launching successful products

• Passionate about creating user-centric solutions

• Excellent communication and leadership skills
Answered by AI
Add your answer
Q2. Describe the product feature end to end
Ans. 
The product feature allows users to track their daily water intake and set hydration goals.
• Users can input the amount of water they drink throughout the day

• The feature calculates the total water intake and compares it to the user's hydration goal

• Notifications are sent to remind users to drink water if they are below their goal

• Users can view their hydration history and trends over time
Answered by AI
Add your answer

Technical as well as situation based questions were asked

Question 1
1. Motivation and long-term goal while doing the job? 2. What aspects of your parents you follow in your professional life? 3. Why would you leave the organization after one-month (if you think so after joining)?

Easy question for technical

Q1. Personal details
Add your answer
Q2. Salary details
Add your answer

How you use DevOps to improve the efficiency

Q1. Self introduction
Add your answer
Q2. Work experience
Add your answer
Q3. Which department are u working
Add your answer
Q4. Timings and salary
Add your answer

Q1. Name and experience and quality and checking etc
Add your answer
Q2. How can handle ur problem and team work
Add your answer
Q3. Times and salary
Add your answer

About current project and roles and resposibilities etc

Q1. SQL COMPLEX QUERIES and PL SQL, CRON JOBS, SERVICE NOW
Add your answer
Q2. What are difference between SQL and PL SQL
Ans. 
SQL is a standard language for managing relational databases, while PL/SQL is a procedural language extension for SQL.
• SQL is a standard language for querying and manipulating data in relational databases.

• PL/SQL is a procedural language extension for SQL, allowing for more complex programming logic.

• SQL is used for data manipulation and retrieval, while PL/SQL is used for writing stored procedures and functions.

• SQL state...read more
Answered by AI
Add your answer
Q3. Explain types of joins?
Ans. 
Types of joins are used in databases to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is at least one match in both tables.

• Left Join (or Left Outer Join): Returns all rows from the left table and the matched rows from the right table.

• Right Join (or Right Outer Join): Returns all rows from the right table and the matched rows from the left table.

• Full Join...read more
Answered by AI
Add your answer
Q4. Diffence between correlated and non correlated subquary?
Ans. 
Correlated subquery refers to a subquery that is dependent on the outer query, while non-correlated subquery can be executed independently.
• Correlated subquery is executed for each row processed by the outer query, while non-correlated subquery is executed only once.

• Correlated subquery is slower in performance compared to non-correlated subquery.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT MAX(column2) FROM tab
Answered by AI
Add your answer
Q5. Find departement wise total sal?
Ans. 
To find department wise total salary, sum up the salaries of employees in each department.
• Group employees by department

• Calculate total salary for each department

• Display department wise total salary
Answered by AI
Add your answer

Q1. About the present project , some
Add your answer

Application improvement . Software development cycle.

Q1. About company , family details
Add your answer

Viva type such as some questions given throw. QR Code

Q1. Introduce yourself and what is your aim
Add your answer