Session Handling is done by which part of teradata system?
AMP
PE
BYNET
CLIQUE
TERADATA is Shared _________ architecture.
Nothing
Everything
Disk
Processor
Maximum no. of secondry indexes allowed on single table
64
32
128
256
Clique is a
Group of nodes that share a common set of disk arrays.
Group of AMP's that share a common set of VDisk
Group of PE's used for fault tolerance.
Group of teradata systems.
The rows of every table are distributed among all AMPs
True
False
Each row in teradata system is identified using
Row hash
Row id
Hash map
Hash value
Teradata Basic concepts dictate that a Primary Key can be NULL
Which two statements about the Transient Journal are true?
It permits successful rollback to the last archive
After the transaction is committed, the Before Images are discarded
Transient Journal operation is automatic
Before Images are kept until manually purged
what can be the possible value for the data type number(4,3)?
25.358
1254.663
1.1242
2.425
Which among these are pseudo columns
rowid
sysdate
rownum
all of the above