Teradata For Beginner 2

Question 1

Which Teradata SQL command is used to remove all rows from a table without deleting the table structure?

Accepted Answer

TRUNCATE TABLE

Answer

TRUNCATE TABLE removes all rows quickly without logging individual row deletions, preserving the table structure.

Question 2

In Teradata, what is the purpose of the PRIMARY INDEX (PI)?

Accepted Answer

To determine how rows are distributed across AMPs

Answer

The Primary Index determines which AMP receives and stores a given row based on a hash of the PI column values.

Question 3

What does AMP stand for in Teradata architecture?

Accepted Answer

Access Module Processor

Answer

AMP stands for Access Module Processor, which is the virtual processor responsible for managing data storage and retrieval.

Question 4

Which data type in Teradata is best suited for storing monetary values with exact decimal precision?

Accepted Answer

DECIMAL

Answer

DECIMAL (or NUMERIC) stores exact fixed-point values, making it ideal for monetary amounts where precision matters.

Question 5

What is a Multiset table in Teradata?

Accepted Answer

A table that allows duplicate rows

Answer

A Multiset table permits duplicate rows, unlike a Set table which enforces row-level uniqueness.

Teradata Practice Test