Oracle Database SQL Certified Associate Exam [sql]

Access More Questions

A marketing team wants to segment its customer base into four equal-sized groups (quartiles) based on their total purchase amount to identify top spenders. Which window function is specifically designed to divide an ordered partition of rows into a specified number of ranked groups?

RANK() CUME_DIST() NTILE(4) PERCENT_RANK()

Correct Answer:

NTILE(4)

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