Teradata Teradata SQL

Question 1

Which Teradata SQL clause is used to eliminate duplicate rows from a result set?

Accepted Answer

DISTINCT

Answer

UNIQUE

Answer

NODUPLICATE

Answer

FILTER

Question 2

What does the QUALIFY clause do in Teradata SQL?

Accepted Answer

Filters rows based on window function results

Answer

Defines table partitioning

Answer

Applies row-level security

Answer

Sets the query band

Question 3

Which Teradata join type returns all rows from both tables, including unmatched rows from each side?

Accepted Answer

FULL OUTER JOIN

Answer

LEFT OUTER JOIN

Answer

CROSS JOIN

Answer

INNER JOIN

Question 4

In Teradata, what is the purpose of the SAMPLE clause?

Accepted Answer

Returns a random subset of rows

Answer

Creates a table sample

Answer

Copies statistics to another table

Answer

Sets the row limit for exports

Question 5

Which aggregate function in Teradata returns the middle value of an ordered dataset?

Accepted Answer

MEDIAN

Answer

AVG

Answer

MIDDLE

Answer

CENTER

Question 6

What does the CAST function do in Teradata SQL?

Accepted Answer

Converts a value from one data type to another

Answer

Formats a string for display

Answer

Joins two columns

Answer

Creates a derived column alias