Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)

The correct answer is B. VALIDATE_HIERARCHY D. VALIDATE_ANALYTIC_VIEW. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dwhsg/overview-analytic- views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D

Developing with Autonomous Database

Question

Options

AVALIDATE_LEVELS
BVALIDATE_HIERARCHY
CVALIDATE_DIMENSION
DVALIDATE_ANALYTIC_VIEW
EVALIDATE_MEASURES

How the community answered

(34 responses)

A
6% (2)
B
76% (26)
C
3% (1)
E
15% (5)

Explanation

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dwhsg/overview-analytic- views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D

Topics

#analytic view#VALIDATE_HIERARCHY#VALIDATE_ANALYTIC_VIEW#PL/SQL validation

Community Discussion

No community discussion yet for this question.

Full 1Z0-931 Practice