Teradata Basic Questions

1. What language is used to access a Teradata table?

• SQL

2. What are five Teradata database objects?

• Tables, views, macros, triggers, and stored procedures

3. What are four major components of the Teradata architecture?

• PE, AMPs, Vdisks, and Message Passing Layer

4. What are views? 

• Subset of rows and columns or one or more tables
• Virtual tables
• Window into one or more tables

5. What are macros?

• Predefined, stored set of SQL statements