Database Management Systems

An operational system (also called OLTP - Online Transaction Processing) is used to run day-to-day business operations in real time and is based on current data. This distinguishes it from informational systems (like data warehouses) which support decision-making based on historical data. Operational systems process transactions as they occur.

In a star schema, each dimension table has a one-to-many relationship with the fact table. One dimension record (like one product) relates to many fact records (many sales transactions). This is the fundamental relationship pattern that enables efficient querying in dimensional modeling. Many-to-many and one-to-one don't describe star schema relationships.

Fact tables in dimensional modeling are typically completely normalized - they contain only foreign keys to dimension tables and numeric measures. The normalization prevents update anomalies and ensures efficient querying. Dimension tables, by contrast, are often denormalized for query performance. Fact tables don't contain redundant data.

Reconciled data in a data warehouse context is the atomic layer that serves as the single, authoritative source for all decision support systems. It has been cleansed and integrated from source systems. Option A describes source data, C is too narrow (one system), and D describes data marts or departmental data, not reconciled data.

A data warehouse is organized around major subject areas (customers, products, sales) rather than business applications or functions. This subject-oriented design is a core characteristic. Option A is wrong (end users don't update warehouses), B is wrong (warehouses standardize naming), and D is wrong (warehouses contain historical data).

In Informatica PowerCenter, session properties can be configured to create a new log file each time the session runs. This is controlled by the 'Session Log File' options where you can append a timestamp or create separate logs for each run, preventing log files from being overwritten.

In Informatica/Genesys configurations, database connection properties including URL, credentials, and pool settings are specified in connectionpool.properties. Option B is for RPC cluster configuration. Option C refers to cabinet storage. Option D is for general environment settings, not specifically database connections.

The db2as400connectionpool.properties file contains connection parameters specifically for DB2 AS400 database connections (I90 refers to an IBM iSeries/AS400 system identifier). The other property files serve different purposes: connectionpool.properties is generic, rpccluster.properties handles RPC clustering, and environment.properties contains environment settings.

Implicit cursors are automatically created by Oracle for SQL statement processing. Explicit cursors are programmer-defined. The question refers to Oracle's internal processing, which indicates implicit cursors.

Class.forName() dynamically loads a driver class and registers it with the DriverManager. This is the standard JDBC pattern for driver loading. When a driver class is loaded, its static initializer registers the driver with DriverManager, making it available for connections.

Class.forName() dynamically loads a JDBC driver class. When loaded, the driver's static block registers itself with DriverManager. This is the standard JDBC mechanism for driver registration. The other options are not valid JDBC APIs.

Build Management Notification Form (BMNF) in TFS (Team Foundation Server) is the standard document where all database schema changes must be logged. This ensures changes are tracked, reviewed, and deployed smoothly without conflicts or missing migrations.

In LANSA (likely typoed as Lash) projects, database changes are managed through the centralized Data Dictionary repository and the underlying database system, such as SQL Server. In contrast, IIS Server is a web hosting server, not a database engine.

A data warehouse is a centralized repository that stores consolidated data from multiple sources for reporting and analysis. This directly aligns with the definition of a repository of data, meaning the statement is factually true.