1) In Teradata, which of the following is a CLI-based tool for querying and managing data?

2) What is the primary role of the Access Module Processor (AMP) in Teradata?

3) Which of the following is NOT a valid data type in Teradata?

4) What does the EXPLAIN command in Teradata do?

5) Which type of index in Teradata is best suited for improving range-based query performance?

6) In Teradata, which of the following commands would you use to remove duplicate rows from a table?

7) Which of the following statements about Teradata’s Unique Primary Index (UPI) is true?

8) Which type of table in Teradata stores data temporarily and is dropped at the end of the session?

9) What is the function of the Teradata TPT (Teradata Parallel Transporter)?

10) Which type of lock is applied on a table when an exclusive lock is in place?

11) In Teradata, which feature enables row-based partitioning within a table?

12) What does Teradata’s JOIN INDEX primarily optimize?

13) Which of the following commands in Teradata is used to retrieve the first 10 rows of a table?

14) In Teradata, what does the RESTART feature in FastLoad allow?

15) Which of the following commands is used to check for free space in Teradata tables?

16) Which Teradata function allows rounding off numbers to the nearest integer?

17) What is the default locking level in Teradata if no lock type is specified?

18) Which Teradata tool can be used for SQL-based queries, formatting reports, and exporting data?

19) What does the acronym 'AMP' stand for in Teradata?

20) What type of join in Teradata combines rows only when there is a match in both tables?