Tag: databases

PE

AMP

TDP

CLIQUE

VDISK

AMP

BYNET

PE

VDISK

True

False

True

False

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

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

AMP's

Parser

Dispatcher

Bynet

Optimiser

True

False

Multiple

One

Two

All of the above

Unique

Non Unique

Null

Not Null

All of the above