Database Management Systems

DTEXEC is the SQL Server Integration Services (SSIS) command-line utility for executing SSIS packages. It allows packages to be run from command prompts, batch files, or scripts.

Partitioned Primary Index (PPI) is defined during the Physical modeling stage. PPI affects how data is physically stored on disk, making it a physical database design decision rather than logical or extended logical.

When deciding whether to store derived data or calculate it on the fly, access frequency is a key factor - frequently accessed data benefits from storage. Change rating (volatility) is equally important - data that changes often is better calculated to avoid stale values. Maximum NULLs and rows per value are not primary considerations for this decision.

A USI (Unique Secondary Index) subtable stores the index value itself, the RowID pointing to the base table row, and the secondary index's own RowID for internal navigation. AMP number buckets are part of the hash distribution mechanism, not stored in USI subtables. Value-ordered NUSIs have different structures than USIs.

TIME data type stores only time of day (hours, minutes, seconds), not the date component. Hiring an employee requires recording the full date (year, month, day). TIMESTAMP includes both date and time, VARCHAR can store date strings, and CLOB stores character large objects. TIME is the only type that cannot store a complete hire date.

When creating an executable in Oracle EBS, valid execution methods include Oracle Reports, PL/SQL Stored Procedures, and Host (shell scripts). Oracle Forms is not a valid execution method for concurrent programs - Forms are interactive UI components, not batch executables.

INIT call checks database availability (A is true). In IMS COBOL, GOBACK is actually the recommended way to end programs (B is false). When an SSA (Segment Search Argument) contains only the segment name without qualification, byte 9 must be blank (C is true). Basic checkpoint calls don't support GSAM files (D is true).

For GSAM databases, status code 'AI' (Abnormal - Input dataset not available) is issued when a GET call is attempted on a non-existent input dataset. Option A is correct. Status codes AM (Access Method error), AO (Abnormal - Other), and NI (Not Input-related) don't specifically indicate the missing input dataset condition.

Organizational Units (OUs) are the primary containers within a domain for organizing objects like users, groups, and computers. They enable applying Group Policy and delegating administrative authority. Sites are for physical network topology, Trees are collections of Domains, and Trusts are relationships between domains.

DSN9022I is the DB2 message code that indicates successful and normal completion of a utility command execution. The other codes (DSN9025I, DSN9024I, DSN9023I) represent different states such as termination, warning conditions, or errors in DB2 utility processing.

TEMPLATE is a utility control statement that provides a template mechanism for specifying utility parameters, but it is not specific to the REPAIR utility. It can be used with various DB2 utilities, not exclusively REPAIR. The statement in the question incorrectly suggests a specific relationship that doesn't exist.

Column-oriented storage enables better compression (similar values in a column compress well), reduces I/O (only needed columns are read), and accelerates decision-support queries that access few columns. OLTP is NOT well-suited - it requires row-oriented access for transactional updates. This is a key architectural difference.

Sybase IQ's column-oriented architecture treats every column as an indexed structure by default. Unlike traditional row-based databases that require explicit index creation, Sybase IQ stores data in highly compressed, indexed column structures. This architectural design is fundamental to its performance for analytical queries.

LF (Low Fast) index is optimized for columns with high cardinality like primary keys, providing efficient lookup performance. HG (High Group) is better for low-cardinality columns with many duplicates. HNG (High Non-Grouped) and CMP are not standard Sybase IQ index types for this use case.

Sybase IQ uses write locking where one process writing to a table blocks other processes from updating the same table. This prevents concurrent modification conflicts. The blocking process will fail or wait depending on isolation settings.