Teradata Puzzles

4. Message passing layer.
6. Teradata supports two types of Transaction mode : ANSI and _____.
9. A user is called as _________ Repository.
11. Teradata _________ is the answer of ANSI Stored procedure.
13. A duplication copy of a row located on another AMP within the cluster is called _____?
15. What kind of SQL statement is a GRANT statement?
17. Teradata can be installed on SMP or in MPP.
18. Rowid consists of ROW HASH VALUE and _________ value.
20. Teradata is also called as ___________ nothing architecture.
22. Who manages sessions logon/logoff
23. Primary Index values can be NULL: (write truee or false).
24. Does Base/Interim tables require PERM space? (Y or N)

1. If a View contains more than 1 table called as ______ view.
2. ____ is the super user in Teradata.
3. As your business grows, you can add _______.
5. Exclusive locks are usually applied to ________ and database.
7. We can apply the locks on Database, Table and _______ levels.
8. Which is a multiplatform ARCHIVE/RESTORE Utility in Teradata.
10. A __________ is a group of nodes that share access to the same Disk arrays.
12. Logical disk allocated for AMPs.
13. Which utility loads data into empty tables only.
14. A Fallback cluster is a group of:
16. Which DDL is used to redefine a macro (if it exists) and create it, if doesn't exist.
18. What index provides uniform data distribution through the hashing algorithm?
19. Relational Databases are based on which theory?
21. _____ Read is another term for Access Lock?