Teradata Teradata MCQ 5

Question 1

Which Teradata compression type stores repeated column values once in the table header rather than in each row block?

Accepted Answer

Multi-Value Compression (MVC)

Answer

Multi-Value Compression replaces frequently occurring column values with a small token stored in the row header, reducing row size.

Question 2

In Teradata, what is the maximum number of Secondary Indexes allowed per table?

Accepted Answer

64

Answer

Teradata allows up to 64 secondary indexes (USI + NUSI combined) to be defined on a single table.

Question 3

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

Accepted Answer

POSITION() or INSTR()

Answer

POSITION(substring IN string) and its alias INSTR() both return the 1-based character position of the first match.

Question 4

What does the Teradata 'NORMALIZE' clause do when applied to a table of time periods?

Accepted Answer

Merges overlapping or adjacent time periods into a single contiguous row

Answer

NORMALIZE collapses adjacent or overlapping PERIOD column rows with identical non-period attributes into a single merged row.

Question 5

Which Teradata view provides real-time information about currently running queries and their AMPs usage?

Accepted Answer

DBC.SessionInfoV

Answer

DBC.SessionInfoV shows active sessions and their current SQL text, state, and resource usage in near-real time.

Teradata Practice Test