Multiple choice technology databases

What is the result of a full table scan occurring on Teradata? (Choose two)

  1. All data rows are copied into temporary space

  2. Each data block for a table is read

  3. Each data row is accessed only one

  4. A random set of data blocks for a table is read
Reveal answer Fill a bubble to check yourself
B,C Correct answer
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.

Keep practicing — related questions