Database Management Systems

This appears to be a duplicate of question 132806. In Oracle 10g, after incomplete recovery with RESETLOGS, the database is in a consistent state and doesn't require an immediate full backup (though it's recommended practice). Options A and D are incorrect - incomplete recovery still requires restoring all datafiles and recovering them to a consistent point. Option B is false - RESETLOGS is mandatory after incomplete recovery to reset the redo log sequence.

In NOARCHIVELOG mode, Oracle cannot perform hot/inconsistent backups because there are no archived redo logs to recover transactions. Only consistent (cold) backups are possible where the database is cleanly shut down. ARCHIVELOG mode allows both consistent and inconsistent backups.

ODS (Operational Data Store) contains current DSS data at the lowest level of granularity in a data warehouse architecture. Staging Area is for temporary storage before integration (Option B). Data Warehouse is the integrated repository (Option C). Data Mart contains subsets for specific departments (Option D).

In a star schema, the relationship between a dimension table and fact table is one-to-many - one dimension record relates to many fact records (Option C). Option A (many-to-many) is incorrect because star schemas don't have direct many-to-many. Option B (one-to-one) is wrong because dimensions describe multiple facts. Option D is incorrect since the relationship is specifically one-to-many.

Data Quality Management eliminates bad data and increases data reliability, effectiveness, and usability (Option A). Data Transformations convert data formats (Option B). Data Mining discovers patterns (Option C). Data Security Management protects data access (Option D). Only Option A directly addresses eliminating bad data.

Business Intelligence integrates disparate data into meaningful information (Option A is correct). Option B is wrong because BI deals with both historical and current data for predictive analysis. Option C is incorrect because business rules are defined by business processes, not BI itself. Option D is wrong since only A is true.

Data flows from dispersed sources through collection and integration to become information, then knowledge (Option A correct). Option B is wrong because dispersed data precedes collection. Option C incorrectly swaps information and knowledge. Option D has both wrong order and swapped information/knowledge.

Data Integration involves sourcing data from disparate sources and integrating it into a central repository (Option A correct). Option B describes aggregation/summarization, not integration. Option C describes drill-down operations. Option D describes data distribution, the opposite of integration.

MOLAP (Multidimensional OLAP) pre-computes aggregations and stores data in specialized multidimensional arrays optimized for fast query performance. This makes it ideal for small datasets with complex analytical models since the cubes fit in memory and calculations are pre-done. ROLAP is better suited for large data with simpler models, while HOLAP is a hybrid approach.

Operational Data Store (ODS) serves as an intermediate layer between operational systems and the data warehouse. It provides current, detailed data that supports operational reporting for day-to-day business monitoring, enables drill-through from aggregated warehouse data to details, and supports tactical decision-making with near real-time data access.

In Master Data Management (MDM), the Registry architectural style provides a centralized reference that doesn't store the actual data but maintains indices/pointers to source systems, enabling real-time access to master data across the organization.

Confidentiality (protecting from unauthorized access), Integrity (preventing unauthorized modification), and Availability (ensuring authorized access when needed) form the CIA triad, which are the three fundamental goals of data security.

ELT (Extract, Load, Transform) loads data first into the target system, then uses the target database's processing engine for transformations. This differs from ETL, which transforms before loading using a separate ETL tool.

OLAP cubes are fundamentally multidimensional structures that allow analysis across multiple dimensions (time, geography, product, etc.) simultaneously, enabling complex queries and aggregations that relational databases can't efficiently handle.