Database Management Systems

DB2 performs authorization checks at runtime when the actual SQL statement is executed. BIND time is when the application plan is created and optimized, but authorization is verified later when the plan runs. 'Execution time' and 'End time' are not the correct DB2 terminology.

Index cardinality refers to the number of distinct values in the indexed column(s). A single-column index's cardinality is the count of distinct values in that column. For multi-column (composite) indexes, it's the count of distinct value combinations. Options A and B both correctly capture this definition.

DB2 for z/OS is designed to be accessed from multiple attachment facilities. The four primary environments are TSO (Time Sharing Option), CICS (Customer Information Control System), IMS (Information Management System), and Batch (standard JCL jobs). VSAM is a file system, not an access environment.

RUNSTATS (or RUN STATISTICS) should be executed after any operation that significantly changes data distribution. This includes bulk loads, mass updates, large delete operations, and major batch inserts. Updated statistics help the query optimizer choose efficient execution plans.

In Oracle Reports, Layout objects (frames, repeating frames, fields) collectively define the visual structure and presentation of the report. Data model objects define data sources, PL/SQL objects contain program logic, while frames are just one type of layout component. The question asks what defines the report's appearance.

Tabular Report is the most fundamental report type, displaying data in simple rows and columns format similar to a database table. Form reports present one record per page, Matrix reports show two-dimensional data with row and column headers, while Single Query refers to a data source approach, not a report type. Tabular reports form the foundation for more complex formats.

Groups organize report columns into logical sections, enabling hierarchical display and summary calculations at different levels. Fields are individual data display units, Links connect related data, and Summaries perform calculations. Groups provide the structural organization that determines how columns relate and repeat in the report.

The Data model defines what data gets retrieved by specifying queries, data sources, and column definitions. It acts as the blueprint for data access, determining which tables are queried, how they're joined, and what columns are available. Data Query, Data Wizard, and Data Fields are components or tools, not the comprehensive model itself.

Session Persistence specifically refers to the mechanism of saving HTTP session data to disk when a server shuts down and reloading it when the server restarts. This ensures that user sessions survive server restarts without losing data. Persistence and Server Persistence are too general, while Streaming relates to data transfer, not session storage.

Business Intelligence integrates data from disparate sources into meaningful information for decision-making (Option A). It unearths hidden patterns and trends that can help sustain market leadership (Option D). BI is not limited to historical data only (B is wrong) - it includes current and predictive analytics. While BI may inform business rules, defining them is not its core purpose (C is wrong).

In BI architecture, data flows from dispersed sources (operational systems) to collected data (data warehouse/staging), then to integrated data (integrated warehouse), transformed into information (reports/analysis), and finally into knowledge (insights/decisions). Options B and D incorrectly reverse dispersed and collected data. Option C incorrectly places knowledge before information.

Data Integration involves sourcing data from disparate sources and integrating them into a central repository like a data warehouse. This is Option A. Options B and C describe aggregation/disaggregation (summarization), not integration. Option D describes the opposite of integration - it's about separating data, not combining it.

ELT processes data using the target database engine, unlike ETL which transforms before loading. The data is first extracted and loaded into the target system, then transformed using that system's processing power.

Business Intelligence integrates data from disparate sources into meaningful information (A) and uncovers hidden patterns and trends for competitive advantage (D). BI is not limited to historical data only, and defining business rules is not its primary purpose.