Oracle
1Z0-931-20 · Question #114
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. Explanation/Reference: 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
Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)
Options
- AVALIDATE_LEVELS
- BVALIDATE_HIERARCHY
- CVALIDATE_DIMENSION
- DVALIDATE_ANALYTIC_VIEW
- EVALIDATE_MEASURES
How the community answered
(32 responses)- A6% (2)
- B78% (25)
- C13% (4)
- E3% (1)
Explanation
Explanation/Reference: 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 functions
Community Discussion
No community discussion yet for this question.