Teradata Puzzles

1. Which utility loads data into empty tables only.
3. We can apply the locks on Database, Table and _______ levels.
4. What index provides uniform data distribution through the hashing algorithm?
5. Logical disk allocated for AMPs.
8. Which is a multiplatform ARCHIVE/RESTORE Utility in Teradata.
9. Message passing layer.
16. What kind of SQL statement is a GRANT statement?
17. Which DDL is used to redefine a macro (if it exists) and create it, if doesn't exist.
18. Exclusive locks are usually applied to ________ and database.
20. Teradata is also called as ___________ nothing architecture.
22. Primary Index values can be NULL: (write truee or false).
23. Teradata _________ is the answer of ANSI Stored procedure.

1. A duplication copy of a row located on another AMP within the cluster is called _____?
2. If a View contains more than 1 table called as ______ view.
4. Rowid consists of ROW HASH VALUE and _________ value.
6. Relational Databases are based on which theory?
7. A Fallback cluster is a group of:
10. Does Base/Interim tables require PERM space? (Y or N)
11. As your business grows, you can add _______.
12. A user is called as _________ Repository.
13. Who manages sessions logon/logoff
14. A __________ is a group of nodes that share access to the same Disk arrays.
15. ____ is the super user in Teradata.
19. Teradata supports two types of Transaction mode : ANSI and _____.
21. _____ Read is another term for Access Lock?
23. Teradata can be installed on SMP or in MPP.