Teradata Teradata MCQ 3

Question 1

What is the maximum number of levels supported in a Teradata multi-level partitioned primary index (MLPPI)?

Accepted Answer

32

Answer

Teradata supports up to 32 levels of partitioning in a multi-level partitioned primary index.

Question 2

In Teradata, which join type performs best when one table fits entirely within the spool space of a single AMP?

Accepted Answer

Nested Join

Answer

A Nested Join is efficient when the smaller (inner) table can be replicated to each AMP and row lookups use the primary index.

Question 3

Which Teradata data type is most appropriate for storing monetary values requiring exact decimal arithmetic?

Accepted Answer

DECIMAL/NUMERIC

Answer

DECIMAL/NUMERIC stores exact fixed-point values, avoiding the rounding errors inherent in floating-point types.

Question 4

What does the 'LOCKING FOR ACCESS' modifier do in a Teradata SQL statement?

Accepted Answer

Allows dirty reads by acquiring the lowest-level lock

Answer

LOCKING FOR ACCESS acquires an access lock, the weakest lock level, permitting reads of potentially uncommitted data.

Question 5

In Teradata, what is a 'Global Temporary Table'?

Accepted Answer

A table whose definition persists but data is session-scoped

Answer

Global Temporary Tables have a permanent table definition in the data dictionary but data inserted is private to and lasts only for each user session.

Teradata Practice Test

Teradata Practice Test

Teradata Teradata MCQ 3