Oracle Database SQL (1Z0-071) [oracle-sql]

What does the PARTITION BY clause do in Oracle SQL analytic functions?

Splits the physical table into partitions Divides the result set into groups for the analytic function to operate on Filters rows before the analytic function runs Groups rows like GROUP BY does

Correct Answer:

Divides the result set into groups for the analytic function to operate on

Access more questions from this quiz

Continue to Oracle Database SQL (1Z0-071) [oracle-sql] for more practice questions and the full quiz experience.

Access More Questions