1) In Teradata, which data type is suitable for storing large text data?

2) Which Teradata command allows you to view the most recent SQL executed in a session?

3) Teradata, which utility is primarily used for high-speed data extraction?

4) What type of table in Teradata allows users to store temporary data that persists only for the duration of their session?

5) Which command would you use in Teradata to modify the Primary Index of an existing table?

6) In Teradata, which component primarily manages session handling, query parsing, and dispatching tasks to AMPs?

7) Which Teradata join method is the most efficient for joining two large tables with similar primary index values?

8) What does the MERGEBLOCKRATIO parameter control in Teradata?

9) Which of the following conditions must be true for Teradata to redistribute rows in a HASH JOIN operation?

10) In Teradata, how does the COLLECT STATISTICS command optimize query performance?

11) When using the ROW_NUMBER function in Teradata, how can you remove duplicate rows based on a specific column?

12) Which of the following is a key advantage of Teradata’s Partitioned Primary Index (PPI)?

13) In Teradata, which statement is true about Join Indexes that contain aggregate functions?

14) In Teradata, what does the CHECKSUM feature in a table help detect?

15) Which of the following types of partitioning can improve performance for queries that filter by a range of dates in Teradata?

16) What is the primary function of the TPT API in Teradata’s Parallel Transporter (TPT)?

17) What is an appropriate scenario to use a Secondary Index in Teradata?

18) In Teradata, which SQL function is most suitable for generating a random sample of rows for data analysis?

19) Which Teradata command enables the optimizer to choose the best access path by analyzing data distribution across AMPs?

20) In Teradata, which join type creates a Cartesian product by joining every row from the first table with every row from the second table?