Tag: databases

A virtual table that can be accessed via SQL commands

A virtual table that cannot be accessed via SQL commands

There is no difference between a view and a table

None of these

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