ClearCase Version Control Quiz

The NVL function in SQL requires both parameters to have compatible data types. Since mgrno is a numeric field, the replacement value must also be numeric. NVL(mgrno, 0) correctly substitutes NULL values with 0, while options with '0' or 'none' are strings that would cause type mismatch errors.

Parameter files (SPFILE or PFILE) contain initialization parameters that control how Oracle operates while running. These include memory settings, file locations, and behavioral options. Control files, password files, and redo logs serve different purposes in database operation.

The System Global Area (SGA) is a shared memory region that includes multiple components: buffer cache (data block caching), large pool (for large memory allocations), Java pool (for Java runtime), shared pool (SQL and PL/SQL), and streams pool. All of these are essential SGA components.

In SQL, the DISTINCT keyword must appear immediately after the SELECT keyword and before the column list. This syntax is mandatory - DISTINCT cannot appear elsewhere in the SELECT clause. The keyword is part of the SELECT clause syntax, not a separate clause.

Option A correctly uses concatenation with || operator to combine columns and strings. Option C correctly concatenates string literals (quoted strings) - the column name 'ename' in quotes is a literal string, not a column reference, but this is valid SQL syntax. Options B and D have syntax errors.