Oracle SQL Oracle SQL Advanced Features 2

Question 1

Which Oracle SQL analytic function calculates a running total?

Accepted Answer

SUM() OVER (ORDER BY)

Answer

RUNNING_SUM()

Answer

CUMULATIVE_SUM()

Answer

TOTAL() OVER ()

Question 2

What does the LISTAGG function do in Oracle SQL?

Accepted Answer

Aggregates string values from multiple rows into a single delimited string

Answer

Splits a delimited string into rows

Answer

Lists all aggregate functions available

Answer

Returns the aggregate count of a list

Question 3

Which Oracle SQL function returns the cumulative distribution of a value within a partition?

Accepted Answer

CUME_DIST()

Answer

PERCENT_RANK()

Answer

PERCENTILE_CONT()

Answer

RATIO_TO_REPORT()

Question 4

What is the purpose of the UNPIVOT clause in Oracle SQL?

Accepted Answer

Converts columns into rows

Answer

Converts rows into columns

Answer

Pivots data back to its original position

Answer

Reverses the ORDER BY clause

Question 5

Which Oracle SQL clause creates a window frame for analytic functions based on a range of rows?

Accepted Answer

ROWS BETWEEN

Answer

WINDOW FRAME

Answer

RANGE SET

Answer

BETWEEN ROWS

Question 6

What does the LEAD analytic function do in Oracle SQL?

Accepted Answer

Accesses data from a row after the current row

Answer

Accesses data from a row before the current row

Answer

Returns the first row in a partition

Answer

Calculates the lead time between two dates