Teradata and SQL Database Fundamentals

SUM() is the standard SQL aggregate function for calculating the total of numeric values in a column. Option A uses a non-existent ADD() function, Option B uses TOTAL() which is not standard SQL, and Option D is missing the FROM clause.

TRUNCATE removes all rows from a table without a WHERE clause and cannot be conditional, while DELETE can use WHERE to selectively remove rows. TRUNCATE is faster and resets identity values, whereas DELETE logs individual row deletions.

In SQL, the BETWEEN operator is inclusive. For example, BETWEEN value1 AND value2 includes both value1 and value2 in the query results. Thus, stating that the values specified are exclusive is false.

The LPAD function requires the third parameter to be a string, not a literal asterisk character. The correct syntax would be LPAD(3400,10,'*') with quotes around the padding character. Using * without quotes causes a syntax error.

TRUNC(760.5,-2) truncates to the hundreds place (negative second decimal position), resulting in 700. The negative parameter specifies truncation to the left of the decimal point.

TO_CHAR converts a date to a string with the specified format. Option A correctly passes the unquoted sysdate function and quoted format string. Option B incorrectly quotes 'sysdate' as a literal string, and Option C fails to quote the format string.

The Oracle NVL2 function evaluates the first expression. If it is not null, it returns the second expression, but if it is null, it returns the third expression.

The LIKE operator with 'a%' matches any string starting with 'a'. Option B would end with 'a', Option C is an exact match, and Option D would contain 'a' anywhere.

A primary key can consist of multiple columns, known as a composite primary key. This is common when a single column cannot uniquely identify a row.

In most programming languages, method overloading is based on the method name and its parameter list (signature). Functions cannot be overloaded if they only differ by their return type because the compiler cannot determine which function to call based on usage.

A Terabyte is equal to $10^{12}$ bytes (one trillion bytes) in standard decimal notation (SI units). The other options represent Kilobyte ($10^3$), Gigabyte ($10^9$), or are non-standard figures ($10^{10}$).

Teradata achieves its high performance for OLAP workloads through its Massively Parallel Processing (MPP) architecture. This allows multiple processors to work on different parts of a query simultaneously, distributing the workload across many nodes.

Teradata Tools and Utilities (TTU) is a collection of client applications for loading and extracting data from Teradata databases. FastLoad, MultiLoad, and FastExport are all core TTU components, while DataStage is an IBM ETL product that competes with Teradata utilities rather than being part of TTU.

A Multiset table in Teradata allows duplicate rows to be inserted, unlike a Set table which enforces uniqueness. Volatile and Temporary tables are table types related to scope/lifetime, not duplicate handling. The Multiset option is specifically designed to permit duplicate records.

PMON (Performance Monitor) is a command-line or graphical tool specifically designed to monitor sessions, processes, and resource usage in a Teradata database. SQL Assistant and BTEQ are query execution tools, and Statistics Wizard is used for managing statistics, not for real-time process monitoring.

Teradata follows all 12 of E.F. Codd's relational database rules, making it fully compliant with the relational model. The other options (7, 8, 10) are incorrect numbers - Codd defined 12 rules total.

The question phrasing is unclear ('sessions in single session' is self-contradictory). If interpreted as 'sessions per user', the answer 120 is correct for Teradata. However, the wording makes this ambiguous.

Symmetric Multiprocessing (SMP) and Massively Parallel Processing (MPP) are the two primary hardware architectures used in Teradata systems, whereas PMP and PPP are incorrect distractors.