Oracle

1Z0-515 · Question #34

Which is NOT among Oracle SQL Analytic functions included in Oracle Database 11g?

The correct answer is B. Substring functions. Substring functions are not analytic.

Introduction to Data Warehousing Concepts

Question

Which is NOT among Oracle SQL Analytic functions included in Oracle Database 11g?

Options

ARanking functions
BSubstring functions
CWindow aggregate functions
DLAG/LEAD functions

How the community answered

(20 responses)

A
15% (3)
B
70% (14)
C
10% (2)
D
5% (1)

Explanation

Substring functions are not analytic.

Topics

#SQL analytic functions#window functions#LAG/LEAD#ranking functions

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-515 Practice