Oracle Cloud Infrastructure 2019 Architect Associate — Question 39

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

Answer options

• A. VALIDATE_LEVELS
• B. VALIDATE_HIERARCHY
• C. VALIDATE_DIMENSION
• D. VALIDATE_ANALYTIC_VIEW
• E. VALIDATE_MEASURES

Correct answer: B, D

Explanation

VALIDATE_HIERARCHY and VALIDATE_ANALYTIC_VIEW are the correct functions for validating an analytic view. The other options, while related to validation processes, do not specifically pertain to analytic views as required by the question.