Cognizant Sme Executive Interview Questions and Answers

Hacker rank test includes questions from SQL, Statistics, Data Visualization

Q1. What is nomalization? Difference between rank and dense rank? Find nth highest salary
Ans. 
Normalization is the process of organizing data in a database to eliminate redundancy and improve data integrity.
• Normalization helps in reducing data redundancy by breaking down a large table into smaller, more manageable tables.

• It ensures that each piece of data is stored only once, reducing the chances of inconsistencies.

• Normalization follows a set of rules called normal forms, such as First Normal Form (1NF), Second...read more
Answered by AI
Add your answer

Q1. Difference between percentage and percentile? Give examples where means is greater than median. Case study on payment analytics
Ans. 
Percentage represents a proportion out of 100, while percentile represents a specific position in a dataset.
• Percentage is a relative measure, while percentile is an absolute measure.

• Percentage is used to compare parts of a whole, while percentile is used to compare a value to a distribution.

• Examples where mean is greater than median: skewed right distributions, such as income distribution or test scores with a few high
Answered by AI
Add your answer
Q2. SQL queries using date time functions,where,joins, subqueries
Add your answer

Q1. Questions about your work experience and past projects Basic to intermediate SQL queries
Add your answer

Bsbbshhggjbsnbbdhhxbdnmkakksbhd hmm dbb