What are basic units of Teradata Arcitecture?
PE
AMP
TDP
CLIQUE
VDISK
Intermediate querry results are stored in
BYNET
Each AMP is responsible for a subset of rows from each table.
True
False
It is impossible to have skewed data when employing a Non-Unique Primary Index value?
How does Teradata handle data distribution when performing system configuration changes
Creates an output map to aid in redistributing data
Data distribution is automatic
Creates a reconfig map to help the DBA repartition data
None of the above
Which of the following statements about hashing are true?
The uniqueness value is a component of the row hash value.
In a table that has a NUPI, all rows with the same NUPI value are distributed to the same AMP.
Two Primary Index values that hash to the same row hash value are called hash synonyms.
The output of the hashing algorithm is called the hash map
What are the parts of PE?
AMP's
Parser
Dispatcher
Bynet
Optimiser
Each AMP Corresponds to a particular Vdisk.
NUPI Access is how many AMP Access?
Multiple
One
Two
All of the above
Features of Primary Key are:
Unique
Non Unique
Null
Not Null