Database Management Systems

Transaction activity records individual business events continuously in real-time, making it the most dynamic and frequently changing type of data. Product catalogs, organizational staff, and structural data are structural and change much less frequently.

Data mart design must begin with understanding the business requirements of the department that will use it. This determines what data to include, how to structure it, what metrics to calculate, and how to present the information. Database backups, query performance, data entry processes, and table counts are implementation or operational details that come after defining requirements.

Save Post Change is the PeopleTools event that fires after all database updates have been successfully completed. This event is part of the save processing cycle and occurs after Save Pre Change (which fires before updates) and the actual database commit, making it ideal for post-save processing and validation.

Meta-SQL statements in PeopleTools are stored in Temp Tables within the PeopleSoft database. These temporary tables hold the dynamic SQL fragments and meta-SQL constructs that are resolved and assembled at runtime into executable SQL statements, providing flexibility and reusability in SQL generation.

RESULT_CACHE_MODE=FORCE forces all query results to be cached if possible, ignoring the /*+ no_result_cache */ hint. The FORCE setting means caching happens regardless of explicit hints. Results are cached when they fit in available cache space, but hints that disable caching are overridden.

Internal LOBs can be used as attributes within user-defined data types (object types), allowing structured data with large object components. They also support separate tablespace storage from their parent table for better management. They DO use redo logging (contrary to option B) and CAN be passed as parameters to PL/SQL subprograms (contrary to option C).

DBMS_METADATA package provides GET_DEPENDENT_DDL to retrieve DDL for all objects that depend on a specified object (like a table). GET_DDL can fetch DDL for objects of a specific type within a schema, such as all tables. It doesn't directly track object invalidation status (B is false) or provide tablespace-level object listings (D is false).

When an Application Engine program is loaded into memory in PeopleSoft, the physical tables that the program will operate on are locked to prevent concurrent modifications. This ensures data integrity during program execution and prevents conflicts from other processes.

FREE itab both clears the content AND releases the memory occupied by the internal table. CLEAR only resets the content without releasing memory, and REFRESH typically works like CLEAR. For complete memory deallocation, FREE is the correct command.

Hibernate is a comprehensive ORM framework that handles mapping Java classes to database tables, converting Java data types to SQL data types, and providing querying mechanisms like HQL and Criteria API for data retrieval.

Hibernate provides HQL (object-oriented query language), works with plain POJOs without bytecode instrumentation for transparent persistence, and offers high performance through caching and lazy loading. Automatic composite key generation is not a standard feature.