Oracle
1Z0-931-20 · Question #89
Which two system privileges does a user need to create analytic views? (Choose two.)
The correct answer is D. CREATE ANALYTIC VIEW E. CREATE ATTRIBUTE DIMENSION. Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-
Developing with Autonomous Database
Question
Which two system privileges does a user need to create analytic views? (Choose two.)
Options
- ACREATE ANALYTIC MEASURE
- BCREATE ANALYTIC LEVEL
- CCREATE ANALYTIC HIERARCHY
- DCREATE ANALYTIC VIEW
- ECREATE ATTRIBUTE DIMENSION
How the community answered
(19 responses)- A16% (3)
- B5% (1)
- C5% (1)
- D74% (14)
Explanation
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-
Topics
#analytic views#system privileges#attribute dimensions#CREATE privilege
Community Discussion
No community discussion yet for this question.