A university needs to find the relative rank of ea...

Oracle Database SQL Certified Associate Exam [sql]

Question Number 5

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

Related questions :

A financial analyst needs to calculate the month-over-month sales growth. The ta...
A marketing team wants to segment its customer base into four equal-sized groups...
When calculating a 7-day moving average for website traffic, the data table `Tra...
A data analyst wants to create a report showing each employee's salary alongside...
A data analyst is asked to provide a report showing only the product categories ...
Which of the following SQL queries correctly calculates the number of employees ...
A query is written to find the total sales for each product. Why is the followin...

Oracle Database SQL Certified Associate Exam [sql]

Question Number 5

Count Down:

Related questions :