Oracle Database SQL Certified Associate Exam [sql]

Access More Questions

A university needs to find the relative rank of each student's GPA, defined as the percentage of students with a GPA less than or equal to the current student's GPA. Which window function calculates this cumulative distribution?

PERCENT_RANK() CUME_DIST() NTILE(100) DENSE_RANK()

Correct Answer:

CUME_DIST()

Access more questions from this quiz

Continue to Oracle Database SQL Certified Associate Exam [sql] for more practice questions and the full quiz experience.

Access More Questions