🎴 Flashcard Mode
Database Fundamentals and Teradata
Card1 / 20
Mastered0
Review0
QuestionClick to flip
What is the result of a full table scan occurring on Teradata? (Choose two)
AnswerClick to flip back
A
Each data block for a table is read
B
Each data row is accessed only one
💡 Explanation:
A full table scan (FTS) in Teradata requires reading every single data block containing the table's records. During this operation, each row is accessed exactly once to evaluate filter conditions. FTS does not copy rows to temporary space, nor does it read a random subset of blocks.