Database Management Systems

Oracle's default and most common indexing system is B-Tree (Balanced Tree) indexing. Bitmap indexing is an optional feature in Oracle used for low-cardinality columns, not the default. Functional indexing exists but is not a separate indexing system - it's just indexing on function results. Binary tree is not a standard Oracle indexing term.

The question asks what blocks pointing to data blocks (single indirect, double indirect) are collectively known as. While these are technically part of the inode's indirect pointer structure, 'Metadata' (option B) is the best available answer among the options, though it's not entirely precise - they're more accurately called indirect pointer blocks or simply indirect blocks.

Materialized views store actual data physically, unlike regular views which are just stored queries. When base tables are dropped, the materialized view's data remains in storage. The view may become invalid or unusable, but the data is not automatically deleted. The statement is false.

ORA-12154 indicates the TNS listener cannot resolve the service name. The solution is to verify and correct the tnsnames.ora file parameters. Once corrected and saved, reconnecting is sufficient - restarting the client machine or forms server is unnecessary and excessive.

Conformed dimensions are dimensions that have the same meaning and content across multiple data marts. They enable integration of disparate data marts into a coherent data warehouse by ensuring consistent dimension keys and definitions. This allows drilling across data marts without data integrity issues.

Compound Growth Factor (CGF) measures how data volume grows over time in a data warehouse environment. As historical data accumulates and new sources are added, the data can explode exponentially. CGF quantifies this growth phenomenon, particularly relevant for storage capacity planning and performance management.

In dimensional modeling, fact tables link to dimension tables using surrogate keys - artificially generated keys that are independent of source system keys. Surrogate keys provide stability, performance, and handle slowly changing dimensions better than natural or compound keys.

Casual dimensions (also called degenerate dimensions) are dimension attributes stored in the fact table that have no corresponding dimension table. They explain why a fact exists - such as invoice number, order number, or transaction ID - and provide context without requiring a separate dimension table.

Factless fact tables contain no measures - only foreign keys to dimensions. They are used to track events or represent relationships that occur, such as student attendance, product promotions, or patient visits. The existence of a record indicates the event happened.

A 'wrinkle of time' refers to the latency delay between when data changes in operational systems and when those changes appear in the data warehouse. This lag can occur due to ETL batch windows, processing time, or intentional delays. It's a key data freshness metric.

Derived data is data that is calculated from other data and stored in the data warehouse. Examples include totals, ratios, percentages, or any computed values. Unlike raw data which is copied directly, derived data involves computation before storage.

When integrating acquired company data, the primary challenge is data quality - different formats, standards, duplicates, and inconsistencies must be cleansed and transformed before loading into the enterprise warehouse. Network issues, security concerns, and raw data size are secondary to ensuring clean, consistent integration.

Metadata in a data warehouse contains descriptive information about the structure, meaning, and lineage of data fields. This includes field names, data types, source systems, transformation rules, and business definitions. End users access metadata repositories or data dictionaries to understand field details without needing to examine ETL scripts or technical documentation.

Shrunken dimensions are created through the aggregation process in dimensional modeling. When a dimension table is summarized or aggregated at a higher level (such as aggregating from daily to monthly), it becomes a shrunken dimension. This technique reduces dimension size and improves query performance for summary-level analysis.