Database Management Systems

Buffer busy waits occur when multiple sessions attempt to read or modify the same data block concurrently in the buffer cache. It's a contention issue, not a space or free buffer problem. Dirty buffer checkpointing affects write performance, not read contention.

IMS DB uses a hierarchical data model where data is organized in a tree structure with parent-child relationships. This is different from relational (tables), network (many-to-many), or object-oriented models.

Maximum cardinality specifies the maximum number of entity occurrences that can be associated with a single occurrence of a related entity. Minimum cardinality defines the lower bound, while ERD is the diagram format itself.

In a one-to-many relationship, the entity on the 'one' side is called the parent entity because it can have multiple related child entities, but each child relates to exactly one parent. This is a fundamental concept in hierarchical and relational data modeling. The child entity is on the 'many' side.

An instance entity represents an actual occurrence or realization of a generalized entity type. This is a core modeling concept where you define a generalized template (archetype or supertype) and then create specific instances that conform to that template. In ER modeling, this maps to concrete data records representing the abstract entity definition.

Option A is correct because TKPROF is Oracle's native tool for analyzing SQL performance - it formats trace files to show execution plans, statistics, and timing information for SQL statements. Options B (Jensor), C (SQLProfiler), and D (Strobe) are not Oracle performance analysis tools. TKPROF has been part of Oracle Database for decades and is the standard tool for SQL performance investigation.

Option D is correct because a 10% cache hit ratio means 90% of data requests are going to disk, which is extremely poor performance - significantly increasing cache size will allow more data to stay in memory, reducing expensive disk operations. Changing application code (A) might help but cache sizing is the direct fix. Running queries twice (C) is nonsensical, and doing nothing (B) with a 10% hit ratio is unacceptable - this indicates severe cache starvation.

A personal contacts database is typically small-scale and for individual use. A personal computer provides sufficient resources and is cost-effective for this purpose. Mainframes and supercomputers are designed for enterprise or scientific computing with massive workloads, making them impractical choices.

Performance problems most often originate in the application program itself due to inefficient algorithms, poor data structures, unnecessary computations, or suboptimal database queries. While OS, hardware, and database issues can cause problems, they are less common than application-level issues.

For long-running batch operations, missing, fragmented, or poorly configured indexes are the most common cause of drastic performance degradation. Network delays or vendor limitations rarely account for a run-time disparity of 3 days versus 3 hours.

Data Driven is a valid option in the target settings for Update Strategy transformation. When selected, the Integration Service follows the row-by-row instructions (DD_INSERT, DD_UPDATE, DD_DELETE) coded in the Update Strategy transformation. Options A, B, and C (Merge, Insert into, Mount) are not standard target options in Informatica.

Yes, you can configure sessions to generate a new log file each run. This is done by enabling session log options and configuring the log file name to include timestamps or run instance IDs. Each execution then creates a separate log instead of overwriting.

Query Studio is designed for business users to create ad-hoc (on-demand) reports quickly without deep technical knowledge. Unlike Report Studio, which is for more complex professional report development, Query Studio focuses on simple, immediate reporting needs.

A Package in Cognos Framework Manager is a subset of the model that exposes specific portions of the complete model to report authors. Packages provide security, simplify complexity, and allow different user groups to see only relevant model elements.

A data warehouse is a centralized repository designed specifically for query, analysis, and decision-making. Unlike operational databases that process transactions, data warehouses consolidate historical data from multiple sources to support business intelligence activities. Options A and B describe general databases, while D is about implementation rather than purpose.