1) What is Teradata primarily used for?

2) Which of the following components is NOT part of the Teradata architecture?

3) In Teradata, what is the role of the Parsing Engine (PE)?

4) Which file format is commonly used for data import/export in Teradata?

5) What is the primary key feature of Teradata that allows for high performance in data processing?

6) What is a Primary Index (PI) in Teradata?

7) Which function in Teradata is used to return the current date?

8) In Teradata, what is the maximum number of columns allowed in a single table?

9) What does the BYNET component in Teradata do?

10) Which utility is primarily used for loading large amounts of data into Teradata tables?

11) What type of join does Teradata use when data resides on different AMPs?

12) Which of the following Teradata utilities is used to export data from Teradata tables?

13) In Teradata, what does a “Collect Statistics” command do?

14) Which SQL keyword is used in Teradata to limit the number of rows returned in a query?

15) Which of the following Teradata indexes is primarily used for secondary access?

16) In Teradata, what is a spool space?

17) What command would you use to end a transaction in Teradata?

18) Which Teradata feature automatically redistributes data based on a defined Primary Index?

19) What is Teradata’s system of automatically locking rows to prevent data conflicts?

20) Which function would you use in Teradata to remove trailing spaces from a string?