Teradata Teradata SQL 3

Question 1

What is the role of the GROUP BY clause in a Teradata SELECT statement?

Accepted Answer

Groups rows sharing common column values for aggregate calculations

Answer

Sorts rows by a specified column

Answer

Filters rows before aggregation

Answer

Partitions data across AMPs

Question 2

Which Teradata SQL statement is used to change an existing table's structure, such as adding a column?

Accepted Answer

ALTER TABLE

Answer

MODIFY TABLE

Answer

CHANGE TABLE

Answer

UPDATE TABLE

Question 3

What does the BETWEEN operator do in a Teradata WHERE clause?

Accepted Answer

Tests whether a value falls within an inclusive range

Answer

Checks if a value is in a list

Answer

Compares two tables

Answer

Selects rows at random

Question 4

In Teradata, which window function assigns a unique sequential integer to each row within a partition?

Accepted Answer

ROW_NUMBER()

Answer

RANK()

Answer

DENSE_RANK()

Answer

NTILE()

Question 5

Which Teradata SQL command permanently saves changes made during a transaction?

Accepted Answer

COMMIT

Answer

SAVE

Answer

FINALIZE

Answer

PERSIST

Question 6

What is the result of a Cartesian product in Teradata when two tables are joined without a condition?

Accepted Answer

Every row in the first table is combined with every row in the second table

Answer

Only matching rows are returned

Answer

Duplicate rows are eliminated

Answer

The smaller table is replicated across AMPs