Normalization

Data Integrity

Materialized Views

None of these

True

False

The two tables had their same Primary Index

Teradata redistributed one or both tables by rehashing them by thePrimary index in spool

Teradata placed the smaller table on all AMPs

All the Above

EXPLAIN

HAVING

SHOW

HELP

NOT, Parenthesis AND, OR

Parenthesis,NOT, AND, OR

Parenthesis, OR ,NOT, AND

Parenthesis,NOT, OR, AND

True

False

Self Join

Cartesian Join

Cross Join

Hash Join

CAST

COALESCE

PARTITION BY

RANDOM

INTERSECT

UNION

EXCEPT

MINUS

All the above

None of the above

True

False

Product Join

Exclusion Merge Join

Merge Join

All the Above

Structured Question Language

Structured Query Language

Strong Question Language

None

SELECT

UPDATE

DELETE

ALTER

True

False

DROP

DELETE

TRUNCATE

All the Above

True

False

True

False

SELECT LastName FROM Employee

EXTRACT LastName FROM Employee

SELECT Employee.LastName

None

SELECT *.Employee

SELECT [all] FROM Employee

SELECT * FROM Employee

SELECT Employee

fgg

sb

gsgsg

sgsgs