Teradata Teradata MCQ 3 — Questions and Answers
Question 1: What is the maximum number of levels supported in a Teradata multi-level partitioned primary index (MLPPI)?
- 8
- 16
- 32 (Correct answer)
- 64
Correct answer: 32
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?
- Merge Join
- Hash Join
- Nested Join (Correct answer)
- Product Join
Correct answer: Nested Join
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?
- FLOAT
- BYTEINT
- DECIMAL/NUMERIC (Correct answer)
- REAL
Correct answer: DECIMAL/NUMERIC
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?
- Allows dirty reads by acquiring the lowest-level lock (Correct answer)
- Prevents any other session from reading the table
- Acquires an exclusive write lock
- Enables row-level locking instead of table-level
Correct answer: Allows dirty reads by acquiring the lowest-level lock
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'?
- A table whose definition persists but data is session-scoped (Correct answer)
- A table replicated across all nodes globally
- A permanent table accessible to all users
- A table stored in the global cache
Correct answer: A table whose definition persists but data is session-scoped
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.
Question 6: Which Teradata utility supports both insert and update/delete operations on existing populated tables in a single pass?
- FastLoad
- MultiLoad (Correct answer)
- BTEQ
- FastExport
Correct answer: MultiLoad
MultiLoad supports up to five concurrent DML operations (INSERT, UPDATE, DELETE, UPSERT) on up to five tables in a single job.
Question 7: What is the role of the Teradata 'Parsing Engine' (PE)?
- It parses SQL, creates execution plans, and dispatches steps to AMPs (Correct answer)
- It physically stores and retrieves row data on disk
- It manages network communication between nodes
- It handles user authentication and session limits
Correct answer: It parses SQL, creates execution plans, and dispatches steps to AMPs
The Parsing Engine receives SQL from clients, parses and optimizes it, then dispatches execution steps to the appropriate AMPs.
Teradata Teradata MCQ 3
What is the maximum number of levels supported in a Teradata multi-level partitioned primary index (MLPPI)?