64

32

128

256

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.

True

False

Row hash

Row id

Hash map

Hash value

True

False

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

25.358

1254.663

1.1242

2.425

rowid

sysdate

rownum

all of the above

foreign key constraint

unique key constraint

check constraint

All of the above

deletes data from table_name which cannot be rolled back

deletes data from table_name but can be rolled back

drops table_name

none of the above

both column data type must be same

both colmun data type need not be same

one of the data type must be different

both column data type and length must be same

check (salary>(select salary from emp where uid=10))

check (salary >(select salary from emp where rowid=10 ))

check (salary >2568)

check (salary >select salary from emp where dno=10)

deletes data from table but keeps table structure

deletes data as well table structure

drops table

none of the above

1 11 111 2 3 4

1 2 3 4 11 111

111 11 4 3 2 1

ERROR due to data type mismatch

Union all will remove the duplicate rows from the result set while Union does'nt

Union will remove the duplicate rows from the result set while Union all does'nt

Both Union and Union all will remove duplicate rows from result set

All of the above

12

1234

1200

1234.56

Fastload

Multiload

Tpump

Bteq

True

False

PE

AMP

TDP

CLIQUE

VDISK

AMP

BYNET

PE

VDISK