Teradata Teradata SQL 2

Question 1

Which Teradata SQL command is used to remove all rows from a table without logging individual row deletions?

Accepted Answer

DELETE ALL

Answer

TRUNCATE TABLE

Answer

DROP TABLE

Answer

REMOVE TABLE

Question 2

What is the purpose of the WITH clause (Common Table Expression) in Teradata SQL?

Accepted Answer

Defines a temporary named result set for use within the query

Answer

Locks a table for exclusive access

Answer

Sets query priority

Answer

Enables recursive joins

Question 3

Which string function in Teradata returns the position of a substring within a string?

Accepted Answer

INDEX

Answer

POSITION

Answer

LOCATE

Answer

FIND

Question 4

What does COALESCE return in Teradata SQL?

Accepted Answer

The first non-NULL value from a list of expressions

Answer

The maximum of a set of values

Answer

A concatenated string of all values

Answer

The last non-NULL in a window

Question 5

In Teradata, which keyword is used to sort query results in descending order?

Accepted Answer

DESC

Answer

DESCENDING

Answer

REVERSE

Answer

DOWN

Question 6

Which Teradata function formats a date value as a character string?

Accepted Answer

TO_CHAR

Answer

FORMAT

Answer

DATE_FORMAT

Answer

CONVERT