Database Management Systems

Mapping variables use the double dollar sign prefix ($$) in Informatica. Single dollar sign ($) is for session parameters, triple dollar sign ($$$) is invalid, and hash (#) is used for comments. The double dollar sign correctly identifies mapping parameters and variables.

Writing to a file is faster than writing to a database and eliminates database-related bottlenecks. If performance improves with file output, the target writer was the bottleneck. Writing to Oracle, tables with/without indexes, or constraints doesn't isolate the writer bottleneck as cleanly as a file target.

Native compilation provides better performance for procedures with looping structures because it compiles directly to machine code, eliminating interpretation overhead. Interpreted compilation translates line-by-line at runtime, which is slower for repeated loop iterations.

In Oracle PL/SQL, subprogram overloading (defining multiple procedures with the same name but different parameters) is only supported within packages or as local subprograms, making it a packaged procedure feature here.

In program overloading, procedures are distinguished by their parameter signatures (number, order, and data types). Simply interchanging parameter positions doesn't create a unique signature - 'proc(a,b)' and 'proc(b,a)' where both are the same data type are ambiguous. You need different data types, counts, or names.

A PL/SQL cursor FOR loop automatically manages opening, fetching, and closing the cursor. You do not need to issue explicit OPEN, FETCH, or CLOSE statements.

Packages DO allow privilege control - you can grant EXECUTE privileges on the package, which controls access to all packaged objects. The other statements are true benefits: packages simplify dependencies, load once into memory, and encapsulate logic.

Functions MUST include a RETURN statement because they are designed to compute and return a value. Procedures can execute without returning anything. The RETURN keyword is compulsory in function definitions to specify what value is computed and sent back to the caller.

In many programming languages, such as Pascal or PL/SQL, procedures can contain nested procedure declarations. This allows for helper routines local to the outer procedure scope.

RRDS (Relative Record Data Set) uses fixed-length slots at specific relative record numbers. Once created, a record's position (its slot number) cannot change - it's part of the dataset's fixed structure. You can update the data but not move it to a different position.

When a record spans across multiple Control Intervals (CIs), each CI that contains a segment of that spanned record cannot contain any other data. This is because spanned records require exclusive use of the CIs they occupy to maintain data integrity and proper reassembly of the record segments when read.

QCP (Query Current Processing or Query Control Panel) is the interface for viewing current/active job executions in scheduling systems. This complements LTP (planning view). LTP is for planned jobs, QCP for currently running ones. MCP and Database are not the standard interfaces for monitoring execution status.

Secondary Index in Teradata is primarily used to optimize data access - it provides an alternate path to locate rows without full table scans. Secondary Indexes do NOT determine data distribution across AMPs; only the Primary Index controls distribution. Option A correctly identifies the access purpose.

In PPI (Partitioned Primary Index) tables, rows are first organized by partition number at each AMP, then by hash value within each partition. This two-level sorting (partition then hash) enables efficient partition elimination in queries. Option B correctly states that rows are first sorted by Partition Number.