Multiple choice technology platforms and products

Relational and OLAP structures of Oracle 9i

  1. Resides in different DB Kernel

  2. Resides in same DB Kernel

  3. Resides in DB

  4. Resides in repository
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle 9i integrated relational and OLAP structures within the same database kernel, allowing seamless interoperability. This unified approach eliminated the need for separate OLAP engines and enabled efficient mixed workloads.

AI explanation

Starting with Oracle 9i, the OLAP option was re-architected to run as an integrated analytic engine inside the core Oracle database kernel itself, rather than as a separate bolt-on product (as the earlier Oracle Express-based OLAP had been). This meant relational (ROLAP) tables and multidimensional (OLAP) structures/cubes could both be managed and queried through the same database engine and SQL interface. 'Resides in DB' and 'Resides in repository' are vague/incorrect restatements that don't capture the specific 'same kernel' integration point being tested, and 'different DB Kernel' describes the pre-9i architecture this feature replaced.

Keep practicing — related questions