Database Management Systems

Data warehouse schemas are designed for OLAP (analytical processing) not OLTP, use denormalized structures to optimize query performance, and are organized for easy navigation of business dimensions.

IDMS (Integrated Database Management System) is a classic network database management system designed for mainframes, based on the CODASYL network model. It is not a relational or hierarchical database.

Schema represents the overall logical and physical structure of the entire database, including how data is physically arranged. Subschema is a view of the schema for specific users/applications. Thus Schema represents physical arrangement.

In Siebel CRM, the 'All view' (such as 'All Accounts View') allows users with appropriate visibility privileges to access all records in the database, bypassing typical owner or team restrictions. Other views restrict records by organization, team, or specific administrative groups.

DB2 for i5/OS is specifically designed for IBM System i servers (formerly iSeries and AS/400). DB2 for z/OS runs on IBM mainframe systems. DB2 Data Warehouse Edition and DB2 Enterprise Server Edition are cross-platform products that can be installed on various server types including Linux, Unix, and Windows servers.

DB2 9 supports several authentication types: SERVER (database authenticates), CLIENT (client authenticates), SERVER_ENCRYPT (server with encrypted passwords), and KERBEROS. DCS (Database Connection Services) is not an authentication method - it's a feature that enables access to non-DB2 databases like DB2 for z/OS through DRDA connectivity.

System Maintenance (SYSMAINT) authority is a system-level authority defined in the DB2 Database Manager configuration file, allowing users to perform maintenance operations on the database.

Cataloging a database makes it known to the DB2 system and adds an entry to the system database directory. Control Center, Configuration Assistant, and Command Line Processor (CLP) can all catalog databases. SQL Assist is a coding helper feature within tools that provides SQL syntax help and autocompletion - it cannot perform administrative operations like cataloging.

Fixed-length data types always occupy the same storage regardless of actual content. INT is always 4 bytes, CHAR(n) always uses exactly n bytes, and DOUBLE is always 8 bytes. XML is a variable-length type that stores XML documents and consumes space based on the actual XML content size, making it the correct answer.

CLOB (Character Large Object) stores single-byte character data and can hold up to 2GB, making it suitable for 1000MB. BLOB stores binary data, DBCLOB stores double-byte character data (for Unicode), and GRAPHIC stores fixed-length double-byte strings. The question specifies single-byte character data, so CLOB is correct.

Repeatable Read (RR) is the most restrictive isolation level. It locks all rows scanned during a transaction, ensuring that no other transaction can modify or insert data that would change the result set.

A subscription in Documentum provides quick access to frequently referenced objects by maintaining a reference list that users can easily access without navigating through the full repository structure.

A KeyFlex field (also called Key Flexfield) in Oracle EBS is used to store different segment values for structured data like accounting codes. Option A correctly identifies this. Option B describes Descriptive Flexfields, not Key Flexfields. Option C is a typo and incorrect. Option D is incorrect as Key Flexfields can have multiple segments.

This is a duplicate of question 135753. A KeyFlex field in Oracle EBS stores structured segment values (like account codes). Option A is correct. Option B describes Descriptive Flexfields. Option C is a typo. Option D is wrong as Key Flexfields support multiple segments.