Database Management Systems

In data warehousing, 'stovepipe' data marts refer to isolated, non-integrated systems that do not share common dimensions (conformed dimensions), leading to fragmented and siloed data.

A centipede fact table refers to a fact table with an excessive number of dimensions (often 15+), which makes it difficult to manage and query efficiently. This pattern is considered an anti-pattern in dimensional modeling because it violates the principle of keeping fact tables focused on specific business processes. The name 'centipede' metaphorically describes the table having 'too many legs' (dimensions).

A degenerate dimension is a dimension key (like an invoice or transaction number) that is stored directly in the fact table without joining to a separate dimension table, meaning it has no attributes of its own.

This is a duplicate of question 134480 with reordered options. A consolidated data mart is a second-level data mart that aggregates and combines data from multiple first-level (atomic) data marts, providing summarized, cross-functional views for reporting and analysis.

In Documentum, dm_folder inherits from dm_sysobject, not dm_cabinet. dm_cabinet and dm_folder are siblings in the type hierarchy, both under dm_sysobject.

In Documentum, collection is a transient type used for queries and does not persist permanently. Document, folder, and cabinet are persistent types.

IDMS stands for Integrated Database Management System (or Integrated Data Management System). Option A contains the correct expansion despite a minor spelling error where 'Intergrated' should be 'Integrated'. The other options (B, C, D) represent incorrect expansions.

The primary log file for the Siebel Analytics Web (or Presentation Services) is sawlog.log (or sawlog0.log). Since none of the listed options match this name, 'None of the Above' is the correct choice.

The repository (RPD) file name to be loaded by the Analytics Server is specified in the NQSConfig.ini configuration file. The other file extensions are incorrect for this configuration file.

The OBIEE Repository file has the .rpd extension by convention. This file contains all metadata about data sources, business models, and presentation layer definitions. It is the core configuration file that OBIEE Server uses to execute queries.

In DB2, an alias is defined on a table. If the underlying table or its tablespace is dropped, the alias is not automatically dropped; it remains but becomes invalid. Conversely, a synonym is automatically dropped when its underlying table is dropped.

A schema is a logical container or collection of named database objects, such as tables, views, and indexes, owned by a particular database user. Tables and aliases are individual objects within a schema, making them incorrect.

DB2 does not materialize the entire result set when a cursor is opened. It uses deferred fetch operations, retrieving rows on-demand rather than all at once, which improves memory efficiency and performance.

Opening a cursor does not guarantee that DB2 will immediately fetch and build the entire result set in memory. Rows are often retrieved incrementally as the application executes FETCH statements.