Database Management Systems

Option 3.3 from the File-Aid DB2 Main Menu is the 'Copy' function, which allows copying rows between tables. Option 3.4 is for Object List Processing, 3.2 for SQL Command Manager, and 3.6 for privilege management.

Lookup transformations support three cache types: Static (default, loads entire cache), Dynamic (updates cache during session), and Persistent (cache saved to disk for reuse). These optimize lookup performance for different use cases.

Hibernate mapping files can define mappings for multiple classes/tables in a single .hbm.xml file. The root element can contain multiple elements, each mapping a different database table. This provides flexibility in organizing mappings - you can have one file per table or group related tables.

The element in Hibernate mapping is used for collections requiring key-value pair semantics, typically for one-to-many or many-to-many associations where the collection needs to be indexed. While , , and can also map one-to-many relationships, is specifically designed when you need to maintain index-based access to the collection elements.

To switch the underlying database system, you must update the JDBC driver class, the connection URL, and the Hibernate SQL dialect to match the target database system. Therefore, all of these properties must be changed.

To map and connect to multiple databases in a single Hibernate application, you must configure and instantiate a separate `` for each database, as a single session factory is tied to one database configuration.

Hibernate supports both Native SQL queries and Hibernate Query Language (HQL, often mistyped as HSQL) for querying database records, giving developers flexibility to write database-independent or database-specific queries.

To commit a transaction in Hibernate, you must first retrieve the active transaction from the session and then call its commit method using session.getTransaction().commit(). The other options are syntactically incorrect or do not exist.

All statements are true: Hibernate cannot lazily initialize associations for detached objects, accessing a lazy association outside an active session throws a LazyInitializationException, and lazy fetching avoids loading unnecessary columns or associations.

The cascade attribute in Hibernate mapping accepts 'all', 'persist', 'delete', and other operations like 'merge', 'save-update', 'evict', 'replicate', 'refresh', and 'delete-orphan'. These determine which operations cascade from parent to child entities.

Hibernate fully supports bi-directional associations (such as one-to-many and many-to-one) between data models, allowing navigation from either side of the relationship. This is typically configured using the mappedBy attribute.

Oracle can use password files for authentication, but they are not mandatory disk components. Oracle can authenticate through operating system authentication, network authentication, or other methods without requiring password files.

The DUMP function in Oracle returns a VARCHAR2 value containing the datatype code, length in bytes, and internal representation of an expression - it's for debugging, not backup. Oracle backup is done using Data Pump (EXPDP/IMPDP) or older export/import utilities.

A DB config file in Ab Initio stores connection parameters (like DSN, username, password, connection details) required to connect to databases for reading or writing data.

In Ab Initio, the m_db utility provides various subcommands for interacting with databases, and m_db gendml is specifically used to generate DML files from database tables.