Quiz for Ranking Functions

Q1: Which of the following is a ranking function in SQL?

A. RANK() B. SUM() C. AVG() D. COUNT()

Q2: Which function assigns a unique rank to each row without gaps in ranking values?

A. DENSE_RANK() B. RANK() C. ROW_NUMBER() D. NTILE()

Q3: What does the RANK() function do in SQL?

A. Gives sequential rank without gaps B. Skips rank values for ties C. Assigns random numbers D. Divides rows equally

Q4: What is the difference between ROW_NUMBER() and RANK()?

A. ROW_NUMBER allows ties B. RANK gives unique ranks only C. ROW_NUMBER does not allow ties D. Both skip ranks for ties

Q5: Which ranking function can assign the same rank to tied rows and skip the next rank?

A. RANK() B. DENSE_RANK() C. ROW_NUMBER() D. NTILE()

Q6: What is the use of NTILE(n) in SQL?

A. Calculates percentiles B. Divides data into n buckets C. Assigns even rank to all rows D. Filters top n rows

Q7: Which clause is essential with ranking functions?

A. GROUP BY B. ORDER BY C. HAVING D. DISTINCT

Q8: What will ROW_NUMBER() OVER (ORDER BY salary DESC) return?

A. Ranks employees by name B. Ranks employees by ascending salary C. Ranks employees by descending salary D. No ranking

Q9: Which ranking function provides sequential values with possible duplicates for same values?

A. ROW_NUMBER() B. RANK() C. DENSE_RANK() D. NTILE()

Q10: If two rows have the same rank using RANK(), what is the next rank value?

A. Same B. Next sequential number C. Next number skipped by tie count D. Random

Q11: Which function is most suitable for assigning a row number to each record?

A. RANK() B. DENSE_RANK() C. ROW_NUMBER() D. NTILE()

Q12: What does PARTITION BY do in ranking functions?

A. Filters rows B. Groups rows for ranking C. Sorts rows D. Counts rows

Q13: Which function provides ranking without gaps between tied ranks?

A. DENSE_RANK() B. RANK() C. ROW_NUMBER() D. NTILE()

Q14: Which ranking function always returns a different number for each row?

A. RANK() B. DENSE_RANK() C. ROW_NUMBER() D. NTILE()

Q15: Which ranking function is best used to get top 3 salaries per department?

A. RANK() B. DENSE_RANK() C. ROW_NUMBER() D. NTILE()

Q16: What happens when ORDER BY is not used in OVER clause?

A. Ranking is random B. SQL throws error C. Results are same always D. It still works accurately

Q17: Can we use ranking functions in WHERE clause directly?

A. Yes B. No C. Only with GROUP BY D. Only with JOIN

Q18: Which function divides result set into approximately equal parts?

A. RANK() B. ROW_NUMBER() C. NTILE() D. DENSE_RANK()

Q19: Which ranking function is used to generate a serial number across rows?

A. RANK() B. NTILE() C. ROW_NUMBER() D. LAG()

Q20: To restart ranking for each department, which clause is required?

A. GROUP BY B. ORDER BY C. PARTITION BY D. HAVING

Q21: What does NTILE(4) OVER (ORDER BY salary) do?

A. Returns top 4 salaries B. Splits data into 4 groups C. Ranks rows by 4 levels D. Divides by department