Which best describes Oracle’s OLAP Option for Oracle Database 11g Release 2?

Which best describes Oracle’s OLAP Option for Oracle Database 11g Release 2?

Which best describes Oracle’s OLAP Option for Oracle Database 11g Release 2?

A.
Is stored as relational tables and is considered a ROLAP solution

B.
Uses bitmap indexes

C.
Physically stores OLAP cubes as objects within the relational database

D.
Is available both within the Oracle Database and as a stand-alone solution

Explanation:
Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle
Database 11g. Oracle OLAP cubes deliver sophisticated calculations using simple SQL queries -producing results with speed of thought response times. This outstanding query performance may
be leveraged transparently when deploying OLAP cubes as materialized views enhancing the
performance of summary queries against detail relational tables. Because Oracle OLAP is
embedded in Oracle Database 11g, it allows centralized management of data and business rules
in a secure, scalable and enterprise-ready platform.

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

Ali Abu ibn bender bei

Ali Abu ibn bender bei

C is corect answer. MOLAP and HOLAP models applicable for ORACLE Olap option cube as well.

Reply

Raul

Raul

A)

IS stored in relational tables, but rows and columns are pivoted to maximize the performance when querys are executed, dimentions allows the cube effect in the querys.

i think is the only multidimentional native DBMS is ESSBASE.

Reply