Database Management Systems

DBMS stands for Database Management System, software that manages databases. Option A incorrectly splits 'Database' into two words and uses 'Software' instead of 'System.' Options C and D incorrectly insert 'Business,' which is not part of the standard acronym.

odbccp32.cpl is the 32-bit ODBC Data Source Administrator that opens the ODBC Datasource administration window. ODBC stands for 'Open Database Connectivity', and this file manages database drivers and data source names (DSNs) for Windows applications.

RCU (Repository Creation Utility) creates the metadata repositories and schemas required for Oracle SOA Suite components. It sets up the database structures that SOA Suite uses to store configuration, runtime data, and metadata. RCU does not install or configure the backend database itself - the database must already exist.

A single database server can indeed support multiple application servers simultaneously. This is a common architecture in enterprise systems where several application server instances connect to one central database to serve different users or applications.

The PeopleSoft database server maintains both application data (the actual business data and transactions) and PeopleSoft metadata (information about the application structure, objects, and configuration). Both are essential for the system to function.

The application server is responsible for executing business logic and generating SQL queries based on the metadata stored in the database. It acts as the intermediary between client applications and the database, interpreting business rules and translating them into appropriate database operations.

A logical configuration defines how system components are architecturally structured and connected, regardless of their hardware deployment. When the application and database servers are installed on the same physical machine, they are logically separated but physically shared, representing a logical configuration rather than a physical one.

The Usage property determines how a query item can be used in reports - as a fact, attribute, or identifier. This is the most critical setting to verify immediately after import because it affects how data can be aggregated and displayed. Format, Data Type, and Semi-Aggregate are important but secondary to Usage.

When importing metadata, Framework Manager can automatically generate relationships between query subjects based on existing primary key and foreign key relationships in the database. This saves significant modeling time and ensures referential integrity. Multiple connections must be defined separately, usage is set manually, and join types are not automatically converted.

The Stored Procedure stage in IBM InfoSphere DataStage is specifically designed to call stored procedures in databases such as DB2. It allows integration of database procedural logic into data integration jobs.

Mandatory background processes in Oracle9i include PMON, SMON, DBWR, LGWR, and CKPT. MMON (Memory Monitor) was introduced later in Oracle 10g to support automatic workload repository features.

An Oracle Database can have up to 8 control files. These are multiplexed copies for redundancy. The question asks for the maximum number, and 8 is the correct answer.